1.select m.* from transaction as m
2.inner join (
3. select IdMeter, `date_time`, max(`id`) mv
4. from transaction
5. group by IdMeter, `date_time`
6.) mt on m.IdMeter=mt.IdMeter and m.`date_time` = mt.`date_time` and m.`id`=mt.mv
7.WHERE m.IdMeter='611190001' and m.`date_time` >= '2022-05-01 00:00:00' and m.`date_time` <= '2022-05-02 23:59:59';
