MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Need help with a Group By clause
Posted by: Bob Field
Date: January 06, 2006 03:07PM

Try this:

select t2.* from (select max(id) as id from test where tag <= 2 group by data) as t1
join test as t2 on t1.id = t2.id order by tag desc

Regards,

Bob.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Need help with a Group By clause
Gabriel Aubut-Lussier
January 06, 2006 02:40PM
Re: Need help with a Group By clause
Bob Field
January 06, 2006 03:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.