declare @N INT SET @N = 3 SELECT * FROM [user] AS [user] WHERE @N = (S

how to find nth highest salary

Question Posted / latha k

103 Answers
178650 Views
Cognizant, IBM, NexGen, Oracle, I also Faced
E-Mail Answers

Answer Posted / latha k

declare @N INT
SET @N = 3
SELECT *
FROM [user] AS [user]
WHERE @N = (SELECT COUNT(DISTINCT(user1.Salary))
FROM [user] AS [user1]
WHERE user.Salary <= user1.Salary
)

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do you know exporting and importing utility?

971

What is a db view?

853

What is 3nf normalization form?

1021

Can you import Microsoft Excel data to SSRS?

123

Do I need a report server to run reports in my application?

153

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1115

What is cross join in sql server joins?

1073

What are the properties of the relational tables?

828

How many types of triggers in sql server?

969

How to create view in stored procedure sql server?

957

What are the restrictions while creating batches in sql server?

1004

How to check table values in sql server?

908

role of sql sever 2005 in database rather than any other database

1886

How to execute stored procedure in select statement sql server?

984

What is encryption key?

115