Easy Way:How to find 3rd higest salary in sql server

Find 3rd highest salary in SQL server

In this tutorial, I am going to show how we can find the 3rd highest salary in SQL Server. In below, the method I want to show you a very easy method so it will help to understand better. The method will take three step so please understand every step carefully.

create table EmployeeSalary 

( 

   ID int identity primary key, 

   Name varchar(20), 

   Salary Decimal  

) 

Insert into EmployeeSalary(Name,Salary)values('Ram',21000) 

Insert into EmployeeSalary(Name,Salary)values('Jhon',50000) 

Insert into EmployeeSalary(Name,Salary)values('Simant',40000) 

Insert into EmployeeSalary(Name,Salary)values('Tom',35000) 

Insert into EmployeeSalary(Name,Salary)values('Alia',25000) 

Insert into EmployeeSalary(Name,Salary)values('Mohan',22000) 

Insert into EmployeeSalary(Name,Salary)values('Raj',23000)

$ads={1}

#Step 1:

In this query, I execute to show the record of  EmployeeSalary table

select * from EmployeeSalary

3rd higest salary in sql server

                                                         

#Step 2: Now, Firstly find the top 3 salaries with descending order

Select  top 3 Name,Salary from EmployeeSalary order by salary desc

3rd higest salary

                                

Let suppose the above record is a table, now we need to find a salary from current table record.

#Step 3: Find the top 1 record in ascending order from the current record 

select top 1 Name,Salary from (select  top 3 Name,Salary from EmployeeSalary order by salary desc) as T  order by salary asc

3rd highest salary 

                                

Finally, we find the 3rd highest salary from SQL Server table

READ MORE - KNOW MORE

Type of key ued In MS SQL

Access Modifier in C# .net

Features of .NET Framework in c#

Sql Server Stored Procedure

Find the higest salary in SQL Server

Sealed Class in c#