SQLize Online / PHPize Online  /  SQLtest Online

create table t ( `id` int, `count` int, `timestamp` datetime ); insert into t values (6282, 120, '2021-11-21 18:51:00'), (6283, 121, '2021-11-21 18:52:00'), (6284, 122, '2021-11-21 18:53:00'), (6285, 123, '21.11 00:00'); SELECT DISTINCT DATE(`timestamp`) as day, FIRST_VALUE(`count`) OVER (PARTITION BY DATE(`timestamp`) ORDER BY `timestamp`) as start_day_count, FIRST_VALUE(`count`) OVER (PARTITION BY DATE(`timestamp`) ORDER BY `timestamp` DESC) as end_day_count FROM t;