Re: GREATEST, LEAST
| From: | Bas Jobsen | Date: | Tue, 12 Mar 2002 02:32:08 +0000 |
| Subject: | Re: GREATEST, LEAST | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17616@lists.php.net to get a copy of this message | ||
>I want to look through the last 15 records
ORDER BY ?? LIMIT 0,15
>d find the highest and/or
> lowest number
SELECT MAX(field),MIN(field)
Op dinsdag 12 maart 2002 03:19, schreef u:
> Could anyone give me an example of how to use GREATEST
> and LEAST in a MySQL query. I want to look through the
> last 15 records in a certain field and find the highest and/or
> lowest number. Thanks.
> Jeff Oien