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 Deloitte SQL PLSQL Interview Questions
How do I start iis on windows server 2012?
What are the different types of gst?
Why acetonitrile and water are used as extraction solvent when analysis melamine? I thought they are miscible and won't be able to separate...
In system.out.println(), what is system, out and println?
What are references in c++? What is a local reference?
Will you be ready to relocate?
Can two tables share a primary key?
who to increase the sale promotion?
State Disadvantages of Apache Kafka?
What is the plus sign called in excel?
how can u check no of records in a file?
What is demand promissory note?
What is system r?
Explain the difference between asp and html? Or why asp is better than html?
How does master slave architecture in the hadoop?