Re: Finding min é max values for each day
Hi, thanks for answer.
I tried this but i get this error : "Unknown column 'maxs.date' in 'on clause'"
select mm.d, mm.mintemp, time(mins.date) as mintime, mm.maxtemp, time(maxs.date) as maxtime
from (
select date(date) as d, min(temp_ext) as mintemp, max(temp_ext) as maxtemp
from releves
group by d
) mm
join releves as mins on mm.d=date(maxs.date) and mm.mintemp=mins.temp
join releves as maxs on mm.d=date(mins.date) and mm.maxtemp=maxs.temp
Thanks,
Subject
Written By
Posted
November 26, 2017 01:07PM
November 26, 2017 07:15PM
Re: Finding min é max values for each day
November 28, 2017 06:56AM
November 28, 2017 09:55AM
November 28, 2017 11:15AM
November 28, 2017 02:12PM
November 28, 2017 02:39PM
November 28, 2017 03:46PM
November 28, 2017 03:56PM
November 28, 2017 04:31PM
November 30, 2017 12:17AM
November 30, 2017 11:11AM
November 30, 2017 12:21PM
November 30, 2017 12:44PM
November 30, 2017 01:12PM