* Boris Villazon > El vie, 29-08-2003 a las 22:05, Daniel Clark escribió: > > > select value from tableName where date in (select max(date) > > > from tableName where id = 4); > > > > > > But, it doesn't work with mysql 4.0. > > > > > > Any ideas? Does anybody had this problem before? > > > > What about: > > > > SELECT value, date > > FROM tablename > > WHERE id = 4 > > ORDER BY date ASC > > > > Just pick the first row. > > > > Thanks Daniel. > > Yes, it's the last option. But, I think that there is a good one. > I think that somebody had this problem before. > > Does anybody have more ideas?
You wanted tha latest date, right? You should use what Daniel suggested, exept you probably want "...ORDER BY date DESC LIMIT 1" -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
