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 14699Post New Deloitte SQL PLSQL Interview Questions
How do we create tasks? What is the difference between task and change request?
why it is so called as xlpe(cross linked poly ethyline) cable?
Describe your experience with the design and implementation of standard & custom infocubes.
How does finally block differ from finalize() method?
What is the keyboard shortcut for paste special?
pls what type of questions asked in interview of appsc polytechnic govt lecturers mail to kram.thulasi@gmail.com
What is the differerence between hysterisis and linearity.
What is movement type for goods issue?
What is the difference between 'company code' and 'company id' when in the fi global settings in the img?
Explain the use of galvanometer?
What is the advantage of linq in c#?
i have done bsc microbiology if they will ask why you joined MBA then what answer we should give
Explain me what is unittest in python?
What is difference between @factory and @dataprovider annotation?
What is the largest value that can be stored in a byte data field?