oracle 数据库的分页
SELECT * FROM table WHERE ROWNUM>90 AND ROWNUM<100;
SELECT * FROM table WHERE ROWNUM<101; minus SELECT * FROM table WHERE ROWNUM<91;
haohao
2004-08-01 22:10:50
评论:0
阅读:1358
引用:0
----------------------------------------------------------------------------------------------------------------------------------------------------------
泡牛吧!
希望越来越多的光棍能够泡到牛
-----------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT * FROM table WHERE ROWNUM>90 AND ROWNUM<100;
SELECT * FROM table WHERE ROWNUM<101; minus SELECT * FROM table WHERE ROWNUM<91;
一切版权属于个人(转载例外)