Thank you.

Hi,

Can anybody please explain me the flow of the below query.
I am not able to understand how this query works.

This query is for finding the Nth highest salary..

SELECT DISTINCT (a.sal)
FROM EMP A
WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B
WHERE a.sal<=b.sal);

If N = 2 then second highest salary will be the o/p.
If N = 3 then third highest salary will be the o/p.
and so on..

Thanks,
Nitin

Question Posted / nitin

5 Answers
15077 Views
Deloitte, Ness Technologies, I also Faced
E-Mail Answers

Answer Posted / nitin

Thank you.

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are sql indexes?

1046

Why use stored procedures?

1140

What is the size of partition table?

1088

What are user defined functions?

1065

what is the difference between truncate and drop statements? : Sql dba

1180

What is scalar function in sql?

1100

what are the types of join and explain each? : Sql dba

1087

what is a control file ? : Sql dba

1089

How can we link a sql database to an existing android app?

1080

What is database white box testing and black box testing?

1157

What are the commands used in sql?

1133

What is varchar example?

1080

What is java sql drivermanager?

1161

What does a pl/sql package consist of?

1015

What is left join example?

1008