Question

oracle数据库中怎么查询emp表中工资最大的三个人的全部信息？

emp的表结构：empno,ename,sal,job,mgr,hiredate,deptno

Answer 1

你好，这个比较的容易，有多重方式可以实现的，我通过嵌套语句实现，我给出一个语句吧。
select top 3 薪水 from emp

Answer 2

select a1.* from (select * from emp order by sal desc) a1 where rownum<=3 ;
呵呵，在Oracle上试过了，运行出了结果

Answer 3

表结构都没有，怎么写？

SELECT empno,ename,sal,job,mgr,hiredate,deptno
FROM (SELECT empno,ename,sal,job,mgr,hiredate,deptno
FROM emp ORDER BY sal DESC) t
WHERE rownum <= 3

Answer 4

select * from emp
where empno=(select empno from emp where rownum<=3 order by sal desc )

Answer 5

select * from emp
where empno in (select empno from emp where rownum<=3 order by sal desc )
order by sql desc