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 a database be repaired?

939

How much memory that we are using in Logshipping Concept?

1755

What is the default schema of your login session in ms sql server?

1015

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1025

What does nvl stand for?

920

What are “phantom rows”?

1628

What are the advantages of user-defined functions over stored procedures in sql server?

989

Do you know what are pages and extents? : SQL Server Architecture

957

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

955

What do you understand by replication in sql server? Mention the different types of replication in sql server.

908

How to assign new column names in a view?

883

What the different components of Replication and what is their use?

1034

In which files does sql server actually store data?

867

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1351

How would you add a section to a table?

988