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

How can you check the version of sql server?

1046

Define outer join?

927

What is a group function explain with an example?

937

What is extended stored procedures?

900

in the physical file layout, where should the transaction log be stored in relation to the data file?

939

How to use “drop” keyword in sql server and give an example?

1088

What does it mean to normalize data?

894

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1002

What is lock escalation and what is its purpose?

921

What is a non-clustered index?

950

What is de-normalization and what are some of the examples of it?

922

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

820

What are the purpose of Normalisation?

998

How ssrs maintain security?

1015

Explain temporary table vs table variable by using cursor alternative?

942