2011/10/20 Halász Sándor <h...@tbbs.net>: > Well done--but.... > > Although, it seems, it is everyone s experience that the desired order is the > order that MySQL yields, all guarantee of that is explicitly deny'd (look up > 'GROUP BY'). It is better to be safe and to use "MIN": > > select * from table1 where messageID NOT IN ( > select MIN(messageID) from table1 > group by userID > ) > >
Thanks. I actually used ORDER BY and LIMIT, I should have used MIN. This is how one learns! Thank you! -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
