RE: [PHP-DB] GREATEST, LEAST
| From: | Beau Lebens | Date: | Tue, 12 Mar 2002 02:23:40 +0000 |
| Subject: | RE: [PHP-DB] GREATEST, LEAST | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17615@lists.php.net to get a copy of this message | ||
Is it perhaps actually MAX and MIN?
SELECT MAX(profit) FROM schemes WHERE revenue>expenses
(not tested, confirmed etc :P)
HTH
Beau
// -----Original Message-----
// From: Jeff Oien [mailto:jeff@webdesigns1.com]
// Sent: Tuesday, 12 March 2002 10:20 AM
// To: PHP-DB
// Subject: [PHP-DB] GREATEST, LEAST
//
//
// 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
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, visit: http://www.php.net/unsub.php
//