mysql取表中《最新》三天的记录，sql语句怎么写
mysql取表中最新三天的记录，sql语句怎么写。从网上查了一条，但这是以当前时间为起点取最近几天的记录select * from rewards where DATE_SUB(CURDATE(), INTERVAL 4 DAY)
MySQL
分享到：
------解决方案--------------------try
select * from tt inner join<br />
(select date(day) as `day` from tt group by date(`day`) order by `day` desc limit 3) a<br />
on date(tt.day)=a.day
Copy after login
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
