Re: invalid use of group function (mysql)
| From: | Johan Holst Nielsen | Date: | Fri, 26 Jul 2002 15:59:47 +0000 |
| Subject: | Re: invalid use of group function (mysql) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-109773@lists.php.net to get a copy of this message | ||
Alexander Ross wrote:
Why am I getting this error? My statement is: SELECT * FROM shots WHERE shot_num = MAX(shot_num) LIMIT 1; There is one record in the table "shots". Its shot_num value is 0.SELECT * FROM shots ORDER BY shot_num DESC LIMIT 1 mvh Johan