oracle SQL语句实现mysql 中limit的函数方法

一：

1 select * from a_matrix_navigation_map
2 
3 where rowid not in(select rowid from a_matrix_navigation_map where rownum<=0) and rownum<=10

二：

1 SELECT * FROM (
2 
3 　　SELECT A.*, rownum r FROM (
4 
5 　　　　SELECT * FROM a_matrix_navigation_map
6 
7 　　) A WHERE rownum <= 10
8 
9 ) B WHERE r > 0

三：

1 SELECT * FROM table WHERE ROWNUM<101;
2 
3 minus
4 
5 SELECT * FROM table WHERE ROWNUM<91;

四：

 1 sql = "select a_id,a_title,a_author,aID,a_time,a_readtime,sID from article order by a_id";
 2 
 3 int a;
 4 
 5 while (rs.next()) {
 6 
 7 a++;
 8 
 9 if (a=ipage+spage)continue;
10 
11 ...
12 
13 }

 

posted @ 2020-12-07 16:51  博二爷  阅读(1412)  评论(0)  编辑  收藏  举报