Group By / Order BY

[Justin]

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.