08 2012 档案

Oracle分页查询语句
摘要：Oracle的分页查询语句基本上可以按照本文给出的格式来进行套用。分页查询格式：SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM = 21其中最内层的查询SELECT * FROM ... 阅读全文
posted @ 2012-08-30 11:03 Jason-Holt 阅读(141) 评论(0) 推荐(0)