SQLize Online / PHPize Online  /  SQLtest Online

create table T (dt datetime, t float); insert into T values ('2022-05-15 09:00:00', 18.36), ('2022-05-15 11:00:00', 21.6), ('2022-05-15 18:00:00', 17.8), ('2022-05-16 09:00:00', 17.3), ('2022-05-16 11:15:00', 18.36), ('2022-05-16 19:45:00', 20.62); select max_t.*, FORMAT(T.dt, 'HH:mm') hour from ( select FORMAT(dt, 'yyyy-MM-dd') as date, max(t) as max_t from T group by FORMAT(dt, 'yyyy-MM-dd') ) max_t join T on FORMAT(T.dt, 'yyyy-MM-dd') = max_t.date and T.t = max_t.max_t; SELECT CONVERT(VARCHAR, dt, 120) AS [Дата, время], T.t AS [Температура] FROM T INNER JOIN ( SELECT CONVERT(VARCHAR, dt, 112) AS D, MAX(t) AS T FROM T GROUP BY CONVERT(VARCHAR, dt, 112) ) AS MT ON MT.D = CONVERT(VARCHAR, T.dt, 112) AND MT.T = T.t ORDER BY 1