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, Nitin5 12005
What is xaml namespace?
What does keep source formatting mean?
What knowledge needed for web services publishing?
What are the difference between laravel 5 & laravel 4?
What do you mean by table control???Where will we use this?
What are the chkdsk parameters?
How to move a drupal site from one host/server to another?
What do you mean by soap?
Explain timestemp datatype in sybase.
The best time to kill a foreground activity in Android?
What has stored procedures in sql and how we can use it?
What is case class? What is case object? What are the Advantages of case class?
What is electrophilic addition reaction?
Explain the properties of sub-query in sql server?
What is main difference between spring and spring boot? : Spring Boot