15 Apr
2014
15 Apr
'14
4:37 p.m.
On 14 April 2014 13:27, Chris Green <cl@isbd.net> wrote:
I have a table with dates, times and temperatures in it. I want to select the maximum temperature for each year, how do I do that?
I don't know what sqlite is capable of and this isn't tested but I'd be looking at something like: SELECT Year(Date) as Year, MAX(IndoorTemperature) as MaxIndoor, MAX(OutdoorTemperature) as MaxOutdoor FROM MyTable GROUP BY Year(Date) -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0844 251 1450 Registered in England (0456 0902) @ 13 Clarke Rd, Milton Keynes, MK1 1LG