Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

Home Forums How to Write a Query to Find the Second Highest Salary in SQL Server? – MindStick
Ask Question

1 Answers

Ravi Vishwakarma
Ravi Vishwakarma 16 Jul 2024
Report Abuse

To retrieve the second-highest salary from a SQL Server table, you can use a subquery with the ROW_NUMBER() function. Here's how you can do it:

SELECT TOP 1 Salary
FROM (
    SELECT Salary, ROW_NUMBER() OVER (ORDER BY Salary DESC) AS RowNum
    FROM YourTableName
) AS SalaryRanked
WHERE RowNum = 2;

In this query:

Inner Query (SalaryRanked): This subquery selects the Salary column from your table (YourTableName) and assigns a row number (RowNum) to each row based on the descending order of Salary.

Outer Query: The outer query selects the Salary from the SalaryRanked subquery where the RowNum equals 2, which corresponds to the second-highest salary.

Make sure to replace YourTableName with the actual name of your table and Salary with the actual column name containing the salaries in your database schema. This query will give you the second-highest salary from your table.

Example 

Select TOP 1 * 
from (
	select *, ROW_NUMBER() OVER(order by Salary Desc ) As RNO 
	from Employees 
) As EMP
where EMP.RNO = 2

OR

select top 1 * from Employees
where Salary < (select MAX(Salary) As Salary from Employees)
order by Salary Desc

Read more 

Write a basic SELECT statement to retrieve data from a SQL Server table.

Help with Writing a Subquery to Get Aggregate Data in SQL Server

SQL Query to Calculate Running Total in SQL Server

MindStick Training
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md