SELECT TOP 1 salary FROM dbo.emp WHERE (salary IN

how to find nth highest salary

Question Posted / abhishek singh

Answer Posted / abhishek singh

SELECT TOP 1 salary
FROM dbo.emp
WHERE (salary IN
(SELECT DISTINCT TOP n salary
FROM dbo.emp
ORDER BY salary DESC))
ORDER BY salary

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

explain declarative management framework (dmf) in sql server 2008?

1044

How can I add Reporting Services reports to my application?

132

How do I make a resultset scrollable?

1014

What is 2nf normalization form?

1204

Why truncate is ddl command?

1118

How to generate create function script on an existing function?

1180

What are the methods used to protect against sql injection attack?

1120

What is cte (common table expression)?

1087

Can group functions be used in the order by clause in ms sql server?

1068

What happens if null values are involved in comparison operations?

1042

How to move database physical files in ms sql server?

1099

What is sql injection? How to protect against sql injection attack?

1044

What are audit control procedures?

1035

What is acid properties?

1191

What is a trigger and its types?

1043