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 > > -- ================================ ing. paredes aguilar, armando http://www.sinapsisperu.com/ Desarrollador
