oracle分页查询
oracle分页查询<br />转自:http://xunqianggong.blog.163.com/blog/static/4004317120097445347528/<br />Oracle的分页查询语句基本上可以按照本文给出的格式来进行套用。<br />分页查询格式:<br />SELECT * FROM <br />(<br />SELECT A.*, ROWNUM RN <br />FROM (SELECT * FROM TABLE_NAME) A <br />WHERE ROWNUM <=
转载
2010-09-27 12:27:00 ·
533 阅读 ·
0 评论