interview

Home / DeveloperSection / Interviews / Write a query to get the second-highest salary.

Ask Question
Ravi Vishwakarma

Ravi Vishwakarma

Follow
Hi, my self Ravi Vishwakarma. I have completed my studies at SPICBB Varanasi. now I completed MCA with 76% form Veer Bahadur Singh Purvanchal University Jaunpur. SWE @ MindStick | Software Engineer | Web Developer | .Net Developer | Web Developer | Backend Engineer | .NET Core Developer

Can you answer this question?

Answer

1 Answers

Ravi Vishwakarma

Ravi Vishwakarma

03-Jul-2024

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.

Read more 

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

MindStick Training

Liked By