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 14139Post New Deloitte SQL PLSQL Interview Questions
what is 'mysqld'? : Sql dba
Some of the functions that we want our macros to accomplish are not possible without first unprotecting the worksheet/workbook with the password?
What is the shortcut for clear formatting?
What is volatile data type?
What are the problems which are being faced by software industries?
What is the function of ctrl e?
Expand BSBDA.
Explain what is object relationship overview?
What do you mean by pointer value and address?
What is the difference between dtd and xsd?
What all information is to be provided in the MDQ?
What do you understand by product costing in sap controlling? : cost center accounting
What is the disadvantage of a call by reference? : abap modularization
Explain difference between dim object as object and dim obj as myform?
What are the types of stored procedures in an sql server?