The max() function is an aggregate function which can be used in
conjunction with GROUP BY in the SELECT or HAVING clause:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html . This
code should work:
select * from table_name group by movid having max(movid).
However, there is a simpler and more efficient solution:
select * from table_name order by movid desc limit 1.
I hope this helps.
Best regards
Roland Kaber
armando wrote:
the field "movid" is type integer or varchar ?
2010/2/6 tech list <bluetm...@gmail.com>
select * from table_name where movid = max(movid);
why the sql above can't work?
Shall I use a sub-select instead?
select * from table_name where movid = (select max(movid) from table_name)
?
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=armand...@gmail.com