SELECT sal FROM ( SELECT DENSE_RANK() OVER (ORDER BY sal DESC) AS ran

how to find nth highest salary

Question Posted / sitakanta rath

Answer Posted / sitakanta rath

SELECT sal FROM
(
SELECT DENSE_RANK() OVER (ORDER BY sal DESC) AS rank, sal
FROM Emp
) T2
WHERE rank=@n

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Do you know data definition language, data control language and data manipulation language?

1091

Explain aggregate functions?

1141

Is the primary key column of a table an index in ms sql server?

1005

Explain important index characteristics?

1080

Why should you use or avoid select * statements?

1078

What is query and its types?

958

what is the difference between count(*) and count(1) ?

1127

What is the difference between a clustered index and a non-clustered index?

1058

Explain left outer join and right outer join?

1092

How do you improve the performance of a SQL Azure Database?

137

How to reaname table name without using sp_Rename in sql server..?

1041

What is a linked server in sql server?

1137

what are the types of indexes? : Sql server database administration

1184

What are the types of containers in ssis?

1235

How to select some specific columns from a table in a query in ms sql server?

1050