你应该先排序了,试试select * from NEWSINFO order by N_TIME DESC where rownum<=10
错了,好象应该: select * from (select * from NEWSINFO order by N_TIME DESC)where rownum<=12 应该对 ,你试试
谢谢大家的帮助,我在程序中使用这样的sql语句: select * from (select * from NEWSINFO where N_DISPLAY ='true' AND N_LOCALNEWS='false' order by N_TIME DESC) where rownum<=5 但是仍然有问题,请大家帮我看看
select * from (select * from NEWSINFO order by N_TIME DESC)where rownum<=12
应该对 ,你试试
select * from (select * from NEWSINFO where N_DISPLAY ='true' AND N_LOCALNEWS='false' order by N_TIME DESC) where rownum<=5
但是仍然有问题,请大家帮我看看