SELECT * FROM (select * from order_list order by start_time desc limit 10) aa ORDER BY start_time
首先倒序查询最新10条信息,然后再用正序排列方式输出。
版权声明:本文为leonnew原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。
SELECT * FROM (select * from order_list order by start_time desc limit 10) aa ORDER BY start_time
首先倒序查询最新10条信息,然后再用正序排列方式输出。