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 10550Post 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 do I sort two columns in excel to match?
What are the different types of protocols?
what does the automatic recovery do? : Sql server administration
what is hvac?
What is glossary of software qa/testing?
Will I need to have an account with a wi-fi service provider?
what is the use of defining cloud architecture?
What exactly does one comprehend the security of a block?
How to see the inductance in a transmission lines
Does wordpress run on php 7?
If a person drawing RS.29000/- as net salary per month... Can any one please provide is his gross salary and total other cuttings...
This perceived force, that seems to want to throw a person off a merry-go-round, is often regarded by physicists as a fictitious force:
How to check the already installed dependencies which are globally installed using npm?
What are the different types of modules in oracle forms?
What is format function?
