mysql取表中《最新》三天的记录,sql语句怎么写mysql取表中最新三天的记录,sql语句怎么写。从网上查了一条,但这是以当前时间为起点取最近几天的记录select * from rewards where DATE_SUB(CURDATE(), INTERVAL 4 DAY) MySQL 分享到: ------解决方案--------------------tryselect * from tt inner join(select date(day) as `day` from tt group by date(`day`) order by `day` desc limit 3) aon date(tt.day)=a.day