查询薪资排名前三的员工姓名和工资（sql和plsql两种方法实现）

查询工资排名前三的员工姓名和工资（sql和plsql两种方法实现）

select ename,sal from emp where 
   empno in (select empno from (select empno,sal from emp order by sal desc )t
   where rownum<4);

 

declare 
  v_name varchar2(10);
  v_sal number(5);
  cursor emp_cursor is select ename,sal from emp order by sal desc;
  begin 
  open emp_cursor;
  for i in 1..3
  loop
  fetch emp_cursor into v_name,v_sal;
  dbms_output.put_line(v_name||','||v_sal);
  end loop;
  close emp_cursor;
  end;

 

我的异常网推荐解决方案：软件开发者薪资,http://www..net/other/1391128.html