Want to become a Vibe Coder? Join Vibe Coding Training here
x
C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
Nth Highest Salary
WhatsApp
amarpal singh
Oct 09
2014
1.3
k
0
0
This is the most popular interview question. How to find Nth Highest Salary of the employee.
SELECT
*
FROM
(
SELECT
ROW_NUMBER () OVER (
ORDER
BY
emp_sal
DESC
) row_number,
empId,emp_salFROM emp
) a
WHERE row_number = N
GO
Script
CREATE
DATABASE
Test
GO
USE Test
GO
IF OBJECT_ID (
'dbo.emp'
)
IS
NOT
NULL
DROP
TABLE
dbo.emp
GO
CREATE
TABLE
dbo.emp
(
empId
INT
NOT
NULL
,
emp_Name
VARCHAR
(15),
emp_sal
INT
)
GO
INSERT
INTO
dbo.emp
(
empId, emp_Name, emp_sal)
VALUES
(101,
'ABC'
, 50000)
GO
INSERT
INTO
dbo.emp(empId, emp_Name, emp_sal)
VALUES
(101,
'CFR'
, 90000)
GO
INSERT
INTO
dbo.emp (empId, emp_Name, emp_sal)
VALUES
(101,
'DFF'
, 70000)
GO
INSERT
INTO
dbo.emp (empId, emp_Name, emp_sal)
VALUES
(101,
'GDD'
, 80000)
GO
INSERT
INTO
dbo.emp (empId, emp_Name, emp_sal)
VALUES
(101,
'DFV'
, 95000)
GO
SELECT *
FROM
(
SELECT
ROW_NUMBER () OVER (
ORDER
BY
emp_sal
DESC
) row_number,
empId,emp_sal
FROM emp
)a
WHERE row_number = 4
GO
Sql
Nth Highest Salary
Sql query
Up Next
Nth Highest Salary