oracle 分页
来源:互联网 发布:薛定谔的网络意思 编辑:程序博客网 时间:2024/06/03 21:34
with tmp_ as
(select us.userUuid, ub.invitationid, us.loginid, ub.createtime, ub.state
from UserAutoUnitBuyInvitation ub, UserSpace us
where us.useruuid = ub.invituseruuid
and ub.useruuid = '4d85cc1b-7580-4663-8983-d5638dc1efa9'
and ub.gameid = 'sfc' or (ub.state ='0' and ub.state ='1')
order by ub.createtime desc)
select invitationid, userUuid, loginid, createtime, state
from (select ROWNUM RNUM,
userUuid,
invitationid,
loginid,
createtime,
state
from tmp_)
where RNUM > 0
and RNUM <= 0 + 5
order by RNUM
(select us.userUuid, ub.invitationid, us.loginid, ub.createtime, ub.state
from UserAutoUnitBuyInvitation ub, UserSpace us
where us.useruuid = ub.invituseruuid
and ub.useruuid = '4d85cc1b-7580-4663-8983-d5638dc1efa9'
and ub.gameid = 'sfc' or (ub.state ='0' and ub.state ='1')
order by ub.createtime desc)
select invitationid, userUuid, loginid, createtime, state
from (select ROWNUM RNUM,
userUuid,
invitationid,
loginid,
createtime,
state
from tmp_)
where RNUM > 0
and RNUM <= 0 + 5
order by RNUM
- oracle分页
- oracle分页
- Oracle分页
- Oracle分页
- oracle分页
- oracle分页
- oracle分页
- oracle分页
- oracle分页
- oracle分页
- Oracle分页
- oracle分页
- Oracle分页
- Oracle分页
- Oracle 分页
- Oracle 分页
- oracle-分页
- Oracle分页
- ORACLE中CONSTRAINT的四对属性
- LaTeX 笔记
- Spring注解的方式注入bean时报异常bean找不到的问题
- 三天玩转win7,你也想?
- 水晶报表(CrystalReports)打印机的选择及背景大小的设定
- oracle 分页
- 软raid命令
- AxisFault: Timeout waiting for connection
- Redis命令参考中文版(Redis Command Reference)
- 类似于QQ游戏百万人同时在线的服务器架构实现
- Posix多线程编程(6)—共享内存
- C# SQLiteHelper类似SqlHelper类实现存取Sqlite数据库
- error occurred during initialization of vm incompatible initial and maximum heap sizes specified
- php中curl的多线程