mysql查询前七天每天最晚时间的数据怎么写？就是根据时间变量time查询前

SELECT * FROM `tbl` WHERE id IN (

SELECT MAX(id) FROM `tbl`

WHERE createdat BETWEEN ADDDATE(DATE_FORMAT(NOW() ,"%Y-%m-%d"), INTERVAL -6 DAY) AND DATE_FORMAT(NOW(),'%Y-%m-%d')

GROUP BY DATE_FORMAT(createdat,'%Y-%m-%d')

)

前提你的表要有自增主键

select * from audit_session where login_time<=(CurDate()-7) and login_time>='DATE_SUB(now() , INTERVAL 1 DAY) 00:00:00'

---