select * from emp where sal=( SELECT DISTINCT (a.sal) FROM EMP A WHERE &am

how to find nth highest salary

Question Posted / sikindar

Answer Posted / sikindar

select * from emp where sal=(
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal));

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is subquery in sql?

1074

Can we store videos inside the sql server table?

990

Where are sql server user names and passwords stored in sql server?

1101

What is query optimization process?

1020

What is the difference between the application object and session object?

1082

What is SQL Azure?

107

What is Transparent Data Encryption?

1010

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

927

Why use update_statistics command in sql server?

1063

Does windows server 2016 come with sql server?

939

What do you mean by data integrity?

1089

How to access the deleted record of an event?

1040

Difference between report and query parameter. Why do we need different type of parameter?

969

Can a synonym name of a table be used instead of a table name in a select statement?

1050

How to create an identity column?

1228