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 13203Post New Deloitte SQL PLSQL Interview Questions
- Deloitte Programming Languages AllOther Interview Questions (2)
- Deloitte JavaScript Interview Questions (1)
- Deloitte TCP IP Interview Questions (1)
- Deloitte C Sharp Interview Questions (1)
- Deloitte ASP.NET Interview Questions (3)
- Deloitte Dot Net Framework Interview Questions (1)
- Deloitte Dot Net General Interview Questions (14)
- Deloitte Microsoft Related AllOther Interview Questions (1)
- Deloitte SQL Server Interview Questions (3) Deloitte SQL PLSQL Interview Questions (2)
- Deloitte Unix Commands Interview Questions (1)
- Deloitte QTP Interview Questions (11)
- Deloitte Manual Testing Interview Questions (11)
- Deloitte Mobile Testing Interview Questions (1)
- Deloitte Test Cases Interview Questions (1)
- Deloitte Testing AllOther Interview Questions (1)
- Deloitte COBOL Interview Questions (3)
- Deloitte JCL Interview Questions (1)
- Deloitte DB2 Interview Questions (2)
- Deloitte Core Java Interview Questions (3)
- Deloitte Servlets Interview Questions (1)
- Deloitte Teradata Interview Questions (2)
- Deloitte Business Objects Interview Questions (3)
- Deloitte Cognos Interview Questions (2)
- Deloitte Informatica Interview Questions (21)
- Deloitte Data Stage Interview Questions (1)
- Deloitte SAS Interview Questions (1)
- Deloitte Data Warehouse General Interview Questions (2)
- Deloitte HR Questions Interview Questions (30)
- Deloitte SAP ABAP Interview Questions (44)
- Deloitte SAP SD (Sales & Distribution) Interview Questions (26)
- Deloitte SAP MM (Material Management) Interview Questions (1)
- Deloitte SAP PP (Production Planning) Interview Questions (3)
- Deloitte SAP FI-CO (Financial Accounting & Controlling) Interview Questions (11)
- Deloitte SAP BW (Business Warehouse) Interview Questions (1)
- Deloitte SAP Security Interview Questions (4)
- Deloitte SAP Business One Interview Questions (1)
- Deloitte Siebel Interview Questions (1)
- Deloitte Oracle Apps Technical Interview Questions (5)
- Deloitte Oracle Apps Financial Interview Questions (28)
- Deloitte Oracle Apps SCM Interview Questions (2)
- Deloitte Salesforce Interview Questions (15)
- Deloitte Cloud Computing General Interview Questions (3)
- Deloitte Bio Informatics Interview Questions (1)
- Deloitte Mechanical Engineering Interview Questions (2)
- Deloitte Business Administration Interview Questions (1)
- Deloitte Banking Finance Interview Questions (12)
- Deloitte Human Resources Interview Questions (9)
- Deloitte Audit Interview Questions (6)
- Deloitte CompanyAffairs CS Interview Questions (1)
- Deloitte Taxation Interview Questions (7)
- Deloitte Accounting General Interview Questions (10)
- Deloitte Accounting AllOther Interview Questions (33)
- Deloitte Call Centre AllOther Interview Questions (4)
- Deloitte General Knowledge_Current Affairs Interview Questions (1)
- Deloitte Everything Else AllOther Interview Questions (6)
- Deloitte General Aptitude Interview Questions (5)
- Deloitte Placement Papers Interview Questions (3)
- Deloitte CISA Certification Interview Questions (1)
- Deloitte MAT Interview Questions (1)
How are javascript and ecma script related?
What is the most powerful capabilities of the modelbinder ?
What does protected internal access modifier mean?
What is a nosql database?
How do you add a number to a macro variable? : sas-macro
What is domain parking?
What happen when I import the same module twice in angular 4?
why incomer bay is required before transformer bay if there are more than 1 nos. of transformer bay.
Is php case sensitive?
What is the cut-off rate?
What is the difference between bootstrap 3 and bootstrap 4?
Explain Reliability Mechanisms in JMS?
What is steaming?
What is candidate key ? What is Alter net key ? & What is foreign key ?
what types of security measures are provided with silverlight?
