HOW TO GET 3RD Highest Employee Salary In Sql 2008 R2

Ans:


Step 1 : Create Table

CREATE TABLE Tbl_Salary
(
    id int NOT NULL primary key,
    Name nvarchar(max) NULL,
    Salary money NULL
)

Then Step 2 : Insert Employee Record


 insert Tbl_Salary values (1001,'Atul Pathrikar',10000);
insert Tbl_Salary values (1002,'Sai Pathrikar', 9000)
insert Tbl_Salary values (1003,'Pravin Pathrikar',8000)
insert Tbl_Salary values (1004,'Vijay Pathrikar',7000);
insert Tbl_Salary values (1005,'Vishal Pathrikar',6000);
insert Tbl_Salary values (1006,'Rohit Pathrikar',5000);
insert Tbl_Salary values (1005,'Kartik Ingle',4000);

Tbl_Salary

 Step 3: Type 1st For Get 3RD highest Salary



SELECT Max(salary)
FROM   Tbl_Salary
WHERE  salary <
 (SELECT Max(salary)  FROM   Tbl_Salary
                 WHERE  salary NOT IN(SELECT Max(salary)
                                      FROM   Tbl_Salary))
                                  
                                   
                                     
                                     

3Rd Highest Salary

                                                                          OR

 Type 2nd To Get 3rd Highest Salary:

SELECT TOP (1) * FROM
   (SELECT TOP (4) Salary ,Name FROM Tbl_Salary ORDER BY salary DESC)
  Salary
ORDER BY salary ASC

3Rd Highest Salary

                                                                           OR

Type 3rd Get 3rd Highest Salary Using CTE(Common Table Expression)

create proc SP_Gethigestsal
(
@higestsalposition int
)
as
with Tbl_ctesal as
(
select *, DENSE_RANK() over(order by salary desc) as HigestSal from Tbl_Salary
)
select Name,Salary from Tbl_ctesal where HigestSal=@higestsalposition
return

--exec  SP_Gethigestsal 3

With CTE Get 3rd Highest Salary

 Try This  Any this 3 Step To Get 3rd Highest Salary

Note: You Also Get 2nd,4th,5th,6th,7th Highest Salary using This Any 1 Sql Query





Thank You For Visit my blog


if you have any query Comment And Share blog,
My YouTube Channel Name: TheAtulpathrikar7,   Atul Pathrikar
watch my all programming and Sql videos on Youtube ,

My-Email_ID: pathrikaratul7@gmainl.com
                       pathrikaratul7@rediffmail.com

send me youre Query on My Mail ID


My Mobile Number : +91-9673178777







Thank You Friends

AP8777