HI, this querey is showing the output for the employees salary. for the wh

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 / mandar

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

Answer Posted / mandar

HI, this querey is showing the output for the employees
salary. for the which employees salary is highest in that
table this query showing the output.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do stored procedures prevent sql injection?

973

How do you write an index?

976

how to enter numeric values as hex numbers? : Sql dba

1073

How do I find duplicates in the same column?

1104

What are the types of join in sql?

1109

Is there any restriction on the use of union in embedded sql?

1164

What is the usage of nvl function?

1044

Enlist the data types that can be used in pl/sql?

1077

Do we need to rebuild index after truncate?

1039

How do I order columns in sql?

1017

Does group by remove duplicates?

1048

How does sql store data?

925

what are integrity rules?

1039

What are the types of queries in sql?

1089

what is top in tsql? : Transact sql

1132