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
5 12952Post New Deloitte SQL PLSQL Interview Questions
Explain access specifiers?
What is the function of pure virtual functions?
In how many ways can a CSS be integrated as a web page?
how much one carpenter can doing shuttering of slab in one day
Explain stream in node.js along with its various types.
What is the use of $_server and $_env?
What is SMTP (Simple Mail Transfer Protocol) ?
how will you find a particular line in debugging if its a infinite loop
Do you know what is similarity and difference between truncate and delete in sql?
Is not equal in sql?
Which variables are stored in heap?
How will iot benefit the end-users?
Does it cover silver or golden ornaments if I have Home insurance?
List the area of applications of data structure.
Explain the role of assembly in the .net framework.