我有一个按ID排序的数据库。我想回显id号最大的那3行但要以
的形式回显id = 5
id = 6
id = 7
与
相对SELECT * FROM `userinfo`ORDER BY `id` ASC LIMIT 3;
将回显
id = 7
id = 6
id = 5
在PHP中
使用派生表限制结果,并在外部查询中再次排序。
SELECT *
FROM (SELECT *
FROM `userinfo`
ORDER BY `id` DESC
LIMIT 3) x
ORDER BY `id` ASC;