0

点赞
0

评论
收藏
分享
举报

oracle趟坑记录—分页

aimee852

关注

0
0
0
1737
发表于 2020-08-31 11:43:15

### **oracle 趟坑记录——分页**---

最近项目用到了oracle语句，在做分页的时候发现和mysql的区别还是挺大的，网上查了点资料，发现有的是不好用的，帮大家踩踩坑哈，大神请绕过，不喜勿喷！

接入正题

先上个首先查到的用法

```
select * from
    (select t.*, rownum rn from
        (
             ”你要进行分页的语句”
        ) t
    where rownum <= page*size)
where rownum > (page-1)*size;

* from
    (select t.*, rownum rn from
        (
             ”你要进行分页的语句”
        ) t
    where rownum <= page*size)
where rownum > (page-1)*size;

from
    (select t.*, rownum rn from
        (
             ”你要进行分页的语句”
        ) t
    where rownum <= page*size)
where rownum > (page-1)*size;

(select t.*, rownum rn from
        (
             ”你要进行分页的语句”
        ) t
    where rownum <= page*size)
where rownum > (page-1)*size;

select t.*, rownum rn from
        (
             ”你要进行分页的语句”
        ) t
    where rownum <= page*size)
where rownum > (page-1)*size;

t.*, rownum rn from
        (
             ”你要进行分页的语句”
        ) t
    where rownum <= page*size)
where rownum > (page-1)*size;

rownum rn from
        (
             ”你要进行分页的语句”
        ) t
    where rownum <= page*size)
where rownum > (page-1)*size;

rn from
        (
             ”你要进行分页的语句”
        ) t
    where rownum <= page*size)
where rownum > (page-1)*size;

from
        (
             ”你要进行分页的语句”
        ) t
    where rownum <= page*size)
where rownum > (page-1)*size;

(
             ”你要进行分页的语句”
        ) t
    where rownum <= page*size)
where rownum > (page-1)*size;

where rownum <= page*size)
where rownum > (page-1)*size;

rownum <= page*size)
where rownum > (page-1)*size;

<= page*size)
where rownum > (page-1)*size;

size)
where rownum > (page-1)*size;

)
where rownum > (page-1)*size;

where rownum > (page-1)*size;

rownum > (page-1)*size;

> (page-1)*size;

-1)*size;

)*size;

size;

;

```

测试结果为第一页好用，然而终于辛辛苦苦的码完代码之后，debug，发现第二页查到的是空？！ 然后我就想说XXXX（哔哔哔哔）！枉我对于你的信任好嘛，难道写技术贴都不测试的嘛？或者是我的使用方法不对？本着百度经验，这个帖子不成那就换下一个试的原则，上下一条：

```
SELECT * FROM (SELECT tt.*, ROWNUM AS rowno
    FROM (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
 * FROM (SELECT tt.*, ROWNUM AS rowno
    FROM (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
FROM (SELECT tt.*, ROWNUM AS rowno
    FROM (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
 (SELECT tt.*, ROWNUM AS rowno
    FROM (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
SELECT tt.*, ROWNUM AS rowno
    FROM (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
 tt.*, ROWNUM AS rowno
    FROM (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
ROWNUM AS rowno
    FROM (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
 AS rowno
    FROM (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
AS rowno
    FROM (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
 rowno
    FROM (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
FROM (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
 (
        ”你要进行分页的语句”
        ) tt
    WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
WHERE ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
 ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
ROWNUM <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
 <= page*size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
size) table_alias
WHERE table_alias.rowno >= (page-1)*size;
) table_alias
WHERE table_alias.rowno >= (page-1)*size;
WHERE table_alias.rowno >= (page-1)*size;
 table_alias.rowno >= (page-1)*size;
-1)*size;
)*size;
size;
;
```

好了，你们要的东西已经找到了，亲测可用，拿走不送，如果您说这样用效率太低？那就请您期待小编我今后的小文章啦……

点击查看更多

全部评论

关于作者

aimee852

TA的个人主页

关注

文章

粉丝

获赞

访问

6210