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 13016Post New Ness Technologies SQL PLSQL Interview Questions
What is Azure Active Directory?
What is the significance of technical settings (specified while creating a table in the data dictionary) ?
What are System Requirements for sap hana?
Safety of on line ups
Where is the mailings tab in word?
What is a repartition coefficient?
What are the different types of stl containers?
What functions are in conio h?
What is auth?
What is meant by annotations in java?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How is rdd distributed?
what are the properties and different types of sub-queries? : Sql dba
What are Queues ? How Queues are diff. in CRM 4.0 and CRM 2011 ?
How to Create an Intranet Site Using ASP.NET MVC?