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 13693Post New Ness Technologies SQL PLSQL Interview Questions
- Ness Technologies OOPS Interview Questions (11)
- Ness Technologies CGI Perl Interview Questions (1)
- Ness Technologies VB Script Interview Questions (3)
- Ness Technologies C Sharp Interview Questions (1)
- Ness Technologies ASP.NET Interview Questions (1)
- Ness Technologies ADO.NET Interview Questions (1)
- Ness Technologies Dot Net AllOther Interview Questions (10)
- Ness Technologies SQL Server Interview Questions (3) Ness Technologies SQL PLSQL Interview Questions (1)
- Ness Technologies Solaris AllOther Interview Questions (1)
- Ness Technologies WinRunner Interview Questions (4)
- Ness Technologies Load Runner Interview Questions (7)
- Ness Technologies QTP Interview Questions (5)
- Ness Technologies Automation Testing AllOther Interview Questions (2)
- Ness Technologies Manual Testing Interview Questions (14)
- Ness Technologies QA Concepts Interview Questions (2)
- Ness Technologies Test Cases Interview Questions (1)
- Ness Technologies Core Java Interview Questions (13)
- Ness Technologies Advanced Java Interview Questions (1)
- Ness Technologies Swing Interview Questions (1)
- Ness Technologies Struts Interview Questions (3)
- Ness Technologies Business Objects Interview Questions (2)
- Ness Technologies Cognos Interview Questions (4)
- Ness Technologies Informatica Interview Questions (3)
- Ness Technologies Micro Strategy Interview Questions (1)
- Ness Technologies Data Warehouse General Interview Questions (1)
- Ness Technologies Design Patterns Interview Questions (1)
- Ness Technologies SAP FI-CO (Financial Accounting & Controlling) Interview Questions (1)
- Ness Technologies Oracle Apps Financial Interview Questions (1)
- Ness Technologies Change Request Management Interview Questions (1)
- Ness Technologies Human Resources Interview Questions (1)
- Ness Technologies Accounting AllOther Interview Questions (2)
- Ness Technologies Call Centre AllOther Interview Questions (1)
- Ness Technologies General Aptitude Interview Questions (1)
- Ness Technologies ISTQB Certification Interview Questions (1)
- Ness Technologies C Code Interview Questions (1)
What are the Types Of Splunk Forwarder?
What are the events in abap/4 language? : abap hr
What is the scope of a content type?
Explain what is tableau data extract?
What does f6 key do?
What is the message server in mqseries?
You have a bag with 6 marbles. One marble is white. You reach the bag 100 times. After taking out a marble, it is placed back in the bag. What is the probability of drawing a white marble at least once?
Can I use openjdk for commercial?
How can you merge two data frames in R language?
How many types of actions are there in quicktest professional (qtp)?
What does noconcatenate do?
How many ways to create array in kotlin?
What is the difference between Hadoop and RDBMS?
What does ctrl r do?
What is the unit of font size in ms word?
