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

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1003

What is a schema? How is it useful in sql servers?

1044

what is bcp? When does it used? : Sql dba

935

Do stored procedures prevent sql injection?

920

Can we create index on primary key?

916

How do I view tables in mysql?

917

Do we need to create index on primary key?

858

Can we create foreign key without primary key?

933

What is rownum and rowid?

985

Which are the different character-manipulation functions in sql?

989

How do you run a query?

958

What will you get by the cursor attribute sql%rowcount?

974

What is null in pl/sql?

1023

What is update query?

922

How to revise and re-run the last sql command?

1101