OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
max() can't work

From: tech list (BlueTMarygmail.com)
Date: Sat Feb 06 2010 - 08:34:32 CST

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