问答题请用一条SQL语句查询出scott.emp表中每个部门工资前3位的数据，显示结果如下： DEPTN0 SAL1 SAL2 SAL3 ________________________________ 10 5000 2450 1300 20 3000 2975 1100 30 2850 1600 1500

【正确答案】select deptno,max(sal) sal1,max(decode(t,2,sal)) sal2,min(sal) sal3 from (select sal,deptno,t from (select empno,ename,sal,row_number() over(partition by deptno order by sal desc) t,deptno from emp) e where e.t<=3) group by deptno

【答案解析】