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 13026Post New Ness Technologies SQL PLSQL Interview Questions
5. What is the maximum transmit power of FlexiEdge BTS
List the type of android application?
In blue prism, exception functions like exceptiondetail() and exceptiontype() cannot be used in recovery mode. Is it true or false?
What is viscosity-coefficient of a liquid?
why you want do business administration and management in Us?
What type of salary are you looking for? : insurance sales
What are eigenvalue and eigenvector?
How can I break Search
Is there any standard object which is also act as junction object ?
Is compensation the most important factor for you when taking a new job?
Is it possible in Blockchain to remove one or more block from the networks?
Is it possible to seo a wordpress site to show it on google first page?
How do you deploy the UiPath tool?
How do I upgrade sql?
What is iqueryable in linq?