MySQL Forums
Forum List  »  MySQL Query Browser

Highest for each day
Posted by: Thomas Baron
Date: May 11, 2010 03:39PM

I'm trying to figure out an efficient query that returns 1 row for each day between two dates. The selected row for each day has the highest value of some field for that day.

Something like:
SELECT * FROM table ORDER BY rain DESC LIMIT 1 PER DAY

except obviously that per day part doesn't exist in mysql...

thanks for any help you can provide



Edited 1 time(s). Last edit at 05/11/2010 03:26PM by Thomas Baron.

Options: ReplyQuote


Subject
Written By
Posted
Highest for each day
May 11, 2010 03:39PM
May 12, 2010 06:24AM


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.