oracle输出无数据类型,Oracle-sql查询,在没有number数据类型列时打印奇数行

如果

EID

ROW_NUMBER

提供这样的信息:

SQL> with temp as

2 (select empno, ename, job sal,

3 row_number() over (order by null) rn

4 from emp

5 )

6 select *

7 from temp

8 where mod(rn, 2) = 1;

EMPNO ENAME SAL RN

---------- ---------- --------- ----------

7369 SMITH CLERK 1

7521 WARD SALESMAN 3

7654 MARTIN SALESMAN 5

7782 CLARK MANAGER 7

7839 KING PRESIDENT 9

7876 ADAMS CLERK 11

7902 FORD ANALYST 13

7 rows selected.

SQL>

ROWNUM

您已尝试使用:

SQL> with temp as

2 (select empno, ename, job sal,

3 rownum rn

4 from emp

5 )

6 select *

7 from temp

8 where mod(rn, 2) = 1;

EMPNO ENAME SAL RN

---------- ---------- --------- ----------

7369 SMITH CLERK 1

7521 WARD SALESMAN 3

7654 MARTIN SALESMAN 5

7782 CLARK MANAGER 7

7839 KING PRESIDENT 9

7876 ADAMS CLERK 11

7902 FORD ANALYST 13

7 rows selected.

SQL>