oracle 分页写法 

select * from (
 select ROWNUM RN ,TT.* from (	
 select * from YQ_FEED_BACK_MESSAGE WHERE MODEL_TYPE = 3 AND FEED_BACK_TYPE=4 order by FEED_BACK_DATE DESC
 )TT where rownum<=5
)where RN >0

 

posted @ 2018-07-27 14:11  yinder  阅读(163)  评论(0)  编辑  收藏  举报