Highest for each day
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.
Subject
Written By
Posted
Highest for each day
May 11, 2010 03:39PM
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.