17,086
社区成员
发帖
与我相关
我的任务
分享
select *
from (select rownum rn,* from
(select col_name
from test
group by 列1 order by 列2))
where rn=10
SQL> select rownum rn,a.*
2 from (
3 select e.*
4 from emp e
5 order by e.sal) a
6 /
RN EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ----- ---------- --------- ----- ----------- --------- --------- ------
1 7369 SMITH CLERK 7902 1980-12-17 800.00 20
2 7900 JAMES CLERK 7698 1981-12-03 950.00 30
3 7876 ADAMS CLERK 7788 1987-05-23 1100.00 20
4 7521 WARD SALESMAN 7698 1981-02-22 1250.00 500.00 30
5 7654 MARTIN SALESMAN 7698 1981-09-28 1250.00 1400.00 30
6 7934 MILLER CLERK 7782 1982-01-23 1300.00 10
7 7844 TURNER SALESMAN 7698 1981-09-08 1500.00 0.00 30
8 7499 ALLEN SALESMAN 7698 1981-02-20 1600.00 300.00 30
9 7782 CLARK MANAGER 7839 1981-06-09 2450.00 10
10 7698 BLAKE MANAGER 7839 1981-05-01 2850.00 30
11 7566 JONES MANAGER 7839 1981-04-02 2975.00 20
12 7902 FORD ANALYST 7566 1981-12-03 3000.00 20
13 7788 SCOTT ANALYST 7566 1987-04-19 3100.00 20
14 7839 KING PRESIDENT 1981-11-17 5000.00 10
14 rows selected
SQL> select * from (
2 select rownum rn,a.*
3 from (
4 select e.*
5 from emp e
6 order by e.sal) a)
7 where rn=10
8 /
RN EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ----- ---------- --------- ----- ----------- --------- --------- ------
10 7698 BLAKE MANAGER 7839 1981-05-01 2850.00 30