Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 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 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?
