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
14866 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

What is out parameter used for eventhough return statement can also be used in pl/sql?

1077

What is the purpose of normalization?

1040

How many types of privileges are available in sql?

1350

Mention what does plv msg allows you to do?

1121

What is a unique key and primary key and foreign key?

969

How do I create a sql database?

997

List the various privileges that a user can grant to another user?

1043

what is view? : Sql dba

959

How many triggers can be applied on a table?

935

Is pl sql a scripting language?

1030

What is the starting oracle error number? What is meant by forward declaration in functions?

994

What is a unique key?

1054

Does sap use sql?

993

How do I view a table in sql?

1006

Can we create a trigger on view?

895