I have a table containing measurements taken every 5 minutes for a span of 8 months. What I would like to do, is take the max measurement per day and return it. Right now I'm using the following query which does the trick, but would involve a
LOT of typing if I tried to return all the data I need:
SELECT Date, MAX(Temperature) AS Temp
FROM tblTemp
WHERE Date IN ('3/5/2010', '3/6/2010')
GROUP BY Date
This returns the max temperature for 3/5/2010 and 3/6/2010 fine... but you can see how this would be cumbersome doing it all the way through August :-)
View Complete Post