sql分页 

SELECT * FROM (SELECT originTable.*, ROWNUM rn_0192837465 FROM (

   select * from t_contract --要分页的sql
              
        ) originTable ) WHERE rn_0192837465>=1 and rn_0192837465<11

 

posted @ 2015-04-27 16:46  也许还年轻  阅读(82)  评论(0)  编辑  收藏  举报