oracle中rownum和level
rownum 和 level 都是伪列
rownum是oracle给查询返回行分配的编号
可以用rownum=1或rownum< n,不能rownum = n或rownum>n(n>1的自然数)
level常与connect by 合用,代表层级
SELECT ROWNUM FROM DUAL CONNECT BY ROWNUM<10
SELECT LEVEL FROM DUAL CONNECT BY LEVEL<10
oracle中rownum和level
rownum 和 level 都是伪列
rownum是oracle给查询返回行分配的编号
可以用rownum=1或rownum< n,不能rownum = n或rownum>n(n>1的自然数)
level常与connect by 合用,代表层级
SELECT ROWNUM FROM DUAL CONNECT BY ROWNUM<10
SELECT LEVEL FROM DUAL CONNECT BY LEVEL<10