97KC8LwL

1drop table if exists history;
2
3create table history
4(
5history_id int unsigned not null auto_increment primary key,
6property_id tinyint not null,
7created_date datetime
8);
9
10insert into history (property_id, created_date) values(1, date_sub(now(), interval 4 day));
11insert into history (property_id, created_date) values(1, date_sub(now(), interval 3 day));
12insert into history (property_id, created_date) values(1, date_sub(now(), interval 2 day));
13insert into history (property_id, created_date) values(1, date_sub(now(), interval 1 day));
14insert into history (property_id, created_date) values(1, now());
15
16insert into history (property_id, created_date) values(2, date_sub(now(), interval 4 day));
17insert into history (property_id, created_date) values(2, date_sub(now(), interval 3 day));
18
19insert into history (property_id, created_date) values(3, date_sub(now(), interval 2 day));
20insert into history (property_id, created_date) values(3, date_sub(now(), interval 1 day));
21insert into history (property_id, created_date) values(3, now());
22
23select * from history;
24
25select
26 max(history_id) as history_id,
27 property_id,
28 created_date
29from
30 history
31group by
32 property_id;