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

What is a trigger word?

1077

How many types of primary keys are there?

1079

What is the life of an sql statement?

1076

Does pl/sql support create command?

1168

What is rowid in sql?

1054

What is fmtonly in sql?

1161

What are %type and %rowtype for?

1106

Can we call procedure in select statement?

1110

What is the use of sqldataadapter?

1026

how to select first 5 records from a table? : Sql dba

1028

What is a scalar value in sql?

1122

Define select, insert, create, delete, update, drop keywords

1094

What are sql built in functions?

981

What is primary and foreign key?

1122

What is sql key?

1045