On Thu, Apr 17, 2014 at 11:03:56AM +0100, Mark Rogers wrote:
On 16 April 2014 20:52, steve-ALUG@hst.me.uk wrote:
I'm not sure, it's been a while since I've done SQL, but I think that the above will give the Max Indoor Temperature for the WHOLE TABLE and not just for a particular year, and repeat it once for each year in the table.
The whole point of GROUP BY should be to make sure that stuff like Min/Max/Count/etc apply to the values grouped, so this should work, AIUI.
But you made me doubt myself so I tested it:
Yes, worked perfectly for me too, thanks Mark. It even allows me to select max/min inside and outside temperatures for each year, very neat.
I have another sqlite3 specific question now (goes on from the above), I've started a new thread for it.