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

Does db2 use sql?

938

Can we debug stored procedure?

1018

Why do we create views in sql?

1147

what is the difference between myisam static and myisam dynamic? : Sql dba

1057

What does subquery mean in sql?

1046

What is the difference between microsoft sql and mysql?

958

What is normalisation and its types?

995

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2012

What is a field in a database?

1061

How does cross join work in sql?

1010

Explain the order of sql statement execution?

1043

What is aggregate function in sql?

1030

What is sqlcontext?

1074

What is the difference between left outer join and left join?

990

What is sqlservr exe?

973