Home » SQL & PL/SQL » SQL & PL/SQL » Re: highest salary
Re: highest salary [message #21805] Sun, 01 September 2002 09:50
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
select *
  from (select e.*, rownum rn
          from (select * from emp order by salary) e)
 where rn = 3;
Previous Topic: How to Select with more than one AND in a Where SQL Clause?
Next Topic: To Find the department with max employees
Goto Forum:
  


Current Time: Fri Apr 26 22:46:01 CDT 2024