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 13052Post New Ness Technologies SQL PLSQL Interview Questions
What is the use of inner class?
Is it possible to capture the correlation between continuous and categorical variable?
What is the advantage of .net core?
List server requirements for installing laravel 5.5?
What is a logical partition?
Why do we use multipart/form-data in html form?
Why would an organization need to allow negative stocks?
EXPLAIN WHY YOU CONSIDER YOURSELF SUITED FOR THIS POSITION:
What is the extension of the recovery scenario file in qtp?
What are the types of partner profiles?
What are circular references? How garbage collection deals with circular references.
What is ms excel spreadsheet?
Differentiate between hdam and the hidam databases?
What is a support package? What is its purpose?
In the context of Acoelomate biology, what are some current research areas and unanswered questions in the field?