อยากดึงข้อมูลล่าสุดของแต่ละวันมาแสดงข้อมูล PHP SQL

select m.* from table as m
inner join ( select type, max(value) mv from table group by type) mt
on m.type = mt.type and m.value=mt.mv

select m.* from transaction as m 
inner join (
  select ac_id, `date_in`, max(`transaction_id`) mv 
  from transaction WHERE ac_id='611190001'
  group by `date_in` 
) mt on m.ac_id=mt.ac_id and m.`date_in` = mt.`date_in` and m.`transaction_id`=mt.mv

select m.* from transaction as m 
inner join (
  select ac_id, `date_in`, max(`transaction_id`) mv 
  from transaction 
  group by ac_id, `date_in` 
) mt on m.ac_id=mt.ac_id and m.`date_in` = mt.`date_in` and m.`transaction_id`=mt.mv
WHERE m.ac_id='611190001'