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 14865Post 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 to disable cut, copy and paste in TextBox using jQuery in asp.net?
Hi friends any body having the exp of protocols testing please provide contact details? venga.boy280@gmail.com
What is the meaning of ng in angular 2?
if your dbspace is full then what you will do?
No of ways of doing deployments?
How many databases Microsoft SQL server provides?
What is virtual host in websphere application server?
What is more important to you: the money or the work at Laura Ashley?
Please explain couchdb vs mongodb?
Can you give names of Container classes?
What are virtual business comp. Refered to in Siebel?
Explain the difference between laravel and codeigniter?
What is the purpose of a de-superheater?
What is mongoose odm?
Explain some reserved queue names of ibm websphere mq.
