2,596
社区成员
发帖
与我相关
我的任务
分享【求助】如何倒序SQL的查询结果
我想查询一个时间段内，最新的N条记录，如，
select * from Table where time between '2012-09-03 00:00:00' and '2012-09-03 11:36:59'order by time desc limit 0,100;
因为这样的结果是按时间降序排列的，我想让查询结果按时间升序排列，请问表达式该怎么写？
select * from Table where time between '2012-09-03 00:00:00' and '2012-09-03 11:36:59'order by time desc limit 0,100;
因为这样的结果是按时间降序排列的，我想让查询结果按时间升序排列，请问表达式该怎么写？
...全文
请发表友善的回复…
发表回复
god_fish 2012-09-04
- 打赏
- 举报
OK,3Q
WWWWA 2012-09-04
- 打赏
- 举报
select * from (
select * from Table where time between '2012-09-03 00:00:00' and '2012-09-03 11:36:59'order by time desc limit 0,100) a order by time
select * from Table where time between '2012-09-03 00:00:00' and '2012-09-03 11:36:59'order by time desc limit 0,100) a order by time
WWWWA 2012-09-04
- 打赏
- 举报
select * from (
select * from Table where time between '2012-09-03 00:00:00' and '2012-09-03 11:36:59'order by time desc limit 0,100) a order by time
select * from Table where time between '2012-09-03 00:00:00' and '2012-09-03 11:36:59'order by time desc limit 0,100) a order by time
