共 1 篇  
 oracle分页语句的两种方式
作者: admin　来源: 原创文章　发表于: 2011-10-26 22:49:49
　　第一种：SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM emp ) A WHERE ROWNUM <= 2) WHERE RN >=2; 第二种：select * from( SELECT A.*, ROWNUM RN FROM (SELECT * FROM emp ) A )WHERE RN >= 2 and RN <=4
共 1 篇