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
Answer Posted / avi
Above Answer is correct With small modification that it is a
corelated sub query first it considers sal from a like a.sal
then it compares with all the sal in a sub query the result
will be the no. of counts.This count compares with N value
which matches will be the Nth sal.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is foreign key in sql with example?
how to convert numeric values to character strings? : Sql dba
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Can %notfound return null after a fetch?
Is sqlite free?
How do you create a db file?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is time based sql injection?
Why is stored procedure faster than query?
What are the possible values that can be stored in a boolean data field?
What is difference between pls_integer and integer?
What does where 1/2 mean in sql?
Can you join a table to itself?
What is cursor and its types?
What is dml statement?