Query to get the employee name who is getting 2nd,3rd highest salary.

Oct 11 2010 7:02 AM

Hi all,

Suppose there is a employee table having columns empid,empname,salary respectively.

I need the employee name who is getting 2nd,3rd highest salary.

Thanks

Answers (3)

How to use IN statement with ORDER BY asc/desc in ORACLE queries?

How to use 'HAVING' without 'GROUP BY', what's wrong in this query?