使用如下,可按输入者排序,select CREATE_TIME,TITLE,INPUTER,INTRO from ARTICLE where CREATE_TIME>='2008-01-01') ORDER BY INPUTER DESC limit 0,100
但我想再次查询,从上边的查询结果中再次查询,并按时间排序.
select CREATE_TIME,TITLE,INPUTER,INTRO from ARTICLE where (CREATE_TIME>='2008-01-01') ORDER BY CREATE_TIME DESC limit 0,100如何写可将两句写一句?
但我想再次查询,从上边的查询结果中再次查询,并按时间排序.
select CREATE_TIME,TITLE,INPUTER,INTRO from ARTICLE where (CREATE_TIME>='2008-01-01') ORDER BY CREATE_TIME DESC limit 0,100如何写可将两句写一句?
select *
from (
select CREATE_TIME,TITLE,INPUTER,INTRO
from ARTICLE
where CREATE_TIME>='2008-01-01')
ORDER BY INPUTER DESC
limit 0,100
) t
ORDER BY CREATE_TIME DESC