Detailed answer available on following weblinks --------------------------

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

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

Answer Posted / ms75

Detailed answer available on following weblinks
-----------------------------------------------

1) How does this query work?

<http://www.sqlteam.com/article/find-nth-maximum-value-in-
sql-server>

2) How this query works?

<http://www.dbapool.com/forumthread/topic_4361.html>

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to test for null values?

1060

How does sql developer connect to oracle database?

1012

What is varchar example?

1040

Is sql sequential or random?

1047

Are views faster than queries?

1006

what is a composite key ? : Sql dba

1071

how to write date and time literals? : Sql dba

974

How to return multiple rows from the stored procedure?

979

How do you write a complex sql query?

1098

Can we create view in stored procedure?

982

When are we going to use truncate and delete?

999

What is %s in sql?

1045

How does postgresql compare to mysql?

1043

what is normalization? : Sql dba

1093

what are the drivers in mysql? : Sql dba

1031