List:General Discussion« Previous MessageNext Message »
From:Justin Date:March 17 2007 7:34pm
Subject:Group By / Order BY
View as plain text  
I've got an issue with group / order by.. here's what I'm wondering..

simple table..
date         |         rev
----------------------
20070315          1
20070315          2
20070316          1
20070316          2

Query I'm running
SELECT * FROM `table` GROUP BY `date` order by `rev` DESC

I would think this would return
20070315 - 2
20070316 - 2

but it doesn't it returns

20070315 - 1
20070316 - 1

What am I missing?  I'm trying to do a group by the date and return the 
higher rev..

thanks agian!

Justin. 

Thread
Group By / Order BYJustin17 Mar
  • Re: Group By / Order BYOlexandr Melnyk17 Mar
Re: Group By / Order BYJustin17 Mar
  • Re: Group By / Order BYPeter Brawley17 Mar