SQLize Online / PHPize Online  /  SQLtest Online

create table tbl (id int primary key auto_increment, created_at int); insert into tbl (created_at) SELECT UNIX_TIMESTAMP('2021-08-01 00:00:00') + round(seq * 3600 * 30 * rand()) DAY FROM seq_1_to_60; select id, created_at, date(from_unixtime(created_at)) from tbl order by created_at desc; select * from ( select *, date(from_unixtime(created_at)) created_date, row_number() over (partition by created_date order by created_at desc) rn from tbl) row_numbers where rn = 1; select tbl.* from tbl join ( select max(created_at) max_created_at from tbl group by date(from_unixtime(created_at)) ) last_time on last_time.max_created_at = tbl.created_at;