Above Answer is correct With small modification that it is a corelated su

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

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

Answer Posted / avi

Above Answer is correct With small modification that it is a
corelated sub query first it considers sal from a like a.sal
then it compares with all the sal in a sub query the result
will be the no. of counts.This count compares with N value
which matches will be the Nth sal.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Where do we use pl sql?

1052

What is over () in sql?

1013

what are date and time intervals? : Sql dba

1105

Can a select statement fire a trigger?

1209

What is trigger point?

1058

What is ttitle and btitle?

1113

What is consistency?

1187

How do you write an inner join query?

996

Can primary key be changed?

952

can sql servers linked to other servers like oracle? : Sql dba

1053

Does inner join return duplicate rows?

1039

Why do we go for stored procedures?

1126

what is primary key? : Sql dba

1080

What is trigger in pl sql?

1047

Why triggers are used?

1037