I want the group by result take the latest field, but my query result look like get the random row. Here I described:
Thread Subject Time ----------------------------------------- 5 Re:test 3333333333 1155203794 5 test 3333333333 1155203772 8 test 444 1155203882 8 Re:test 444 1155203897 note: "time" field is INT(11) to store datetime in integer value QUERY --------- select thread, subject, time from jos_sb_messages group by thread order by time RESULT ---------- 5 Re:test 3333333333 1155203794 8 test 444 1155203882 What do I need is: ------------------ 5 Re:test 3333333333 1155203794 8 Re:test 444 1155203897 I am using 3.23.58 for Windows. How to get the result as I expected? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
