SELECT a.* FROM (SELECT ROWNUM AS RO,OP.* FROM OP) A,(SELECT ROWNUM AS RO ,OP FROM OP) B WHERE A.RO = B.RO + :n AND ROWNUM < 11
是关于分页的
rownum 和op是什么意思啊 ()里面是不是两个集合连接的意思啊
...全文
106457打赏收藏
帮忙翻译下列oracle查询语句为一般的sql语句并顺便解释下
SELECT a.* FROM (SELECT ROWNUM AS RO,OP.* FROM OP) A,(SELECT ROWNUM AS RO ,OP FROM OP) B WHERE A.RO = B.RO + :n AND ROWNUM < 11 是关于分页的 rownum 和op是什么意思啊 ()里面是不是两个集合连接的意思啊
猜测 第二个子查询的SELECT字段 应该和第一个的一样
也就是 应该是:
SELECT a.* FROM (SELECT ROWNUM AS RO,OP.* FROM OP) A,(SELECT ROWNUM AS RO ,OP.* FROM OP) B WHERE A.RO = B.RO + :n AND ROWNUM < 11
select * from (select rownum as orm,c.* from rpt_mlog_statistic c where c.bsflag='0') a,(select rownum as orm,c.* from rpt_mlog_statistic c where c.bsflag='0') b
where a.orm=b.orm+200 and rownum<=100
select * from (select rownum as orm,c.* from rpt_mlog_statistic c where c.bsflag='0') a,(select rownum as orm,c.* from rpt_mlog_statistic c where c.bsflag='0') b
where a.orm=b.orm+200 and rownum<=100