Forum

3rd highest salary ...
 
Share:
Notifications
Clear all

3rd highest salary from a table using SQL


jeevan 123
Posts: 18
Topic starter
(@jeevan303500)
Active Member
Joined: 12 months ago

Here you go. How to write an SQL query to find the 3rd highest salary from an employee table?

Input

emp_name    emp_sal

Ramu              1000

Ramesh           4000

Peter               3000

Output

emp_name    emp_sal

Ramesh           4000 

SQL Query 1

 

select * from(
select emp_name, emp_sal, dense_rank() 
over(order by emp_sal desc)t from Employee) 
where t=&n;

To find the 2nd highest sal set n = 2
To find the 3rd highest sal set n = 3 and so on.

How do find out the Top 3 Employees based on their Salary?

Input

emp_num   emp_name  emp_sal

1                 John            5000

2                 Peter            2000

3                 Allen            9000

5                 Merlin           7000

Output 

emp_num   emp_name  emp_sal

1                 Allen            9000

2                 Merlin          7000

3                 John             5000

SQL Query2

With Results As

(
Select Emp_num, emp_name,emp_sal,
Dense_Rank() Over (Order by emp_sal Desc) As Dense_Rank
)

Select * from Results where Results.Dense_Rank<=3

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: