Find 3rd Highest Salary in Sql
Step 1:-
Create a table named "Employee" in your database......
CREATE TABLE employee
(
id int,
name char(20),
dept char(10),
age int,
salary int,
location char(10)
)
Step 2:-
Insert some values into the table "Employee"
Insert into employee values(1,'RAM','Soft Eng',24,30000,'Banglore')
Insert into employee values(2,'Shyam','Progmmer',24,40000,'DELHI')
Insert into employee values(3,'Manoj','Admin',24,50000,'MUMBAI')
Insert into employee values(4,'RAja','Progmmer',24,33000,'DELHI')
Insert into employee values(5,'Sunny','Soft Eng',24,32000,'Banglore')
Insert into employee values(6,'Nukul','Soft Eng',24,31000,'MUMBAI')
Insert into employee values(7,'Laxmi','Data Admin',24,36000,'DELHI')
Insert into employee values(8,'RAmesh','Soft Eng',24,80000,'MUMBAI')
Step 3:-
Execute the table "Employee"
SELECT * FROM employee
Step 4:-
3rd Highest Salary in the table "Employee"
SELECT MIN(salary)
FROM
(SELECT DISTINCT TOP 3 salary FROM
employee ORDER BY
salary DESC)
as a
....................................................................
