SQL命令,并限制再下订单的结果有限
答
SELECT *
FROM
(SELECT column_list
FROM tableX
ORDER BY dates DESC
LIMIT 3
) AS tmp
ORDER BY dates ASC ;