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 15073Post 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)
How do signed and unsigned numbers affect memory?
What is the difference between del() and remove() methods of the list?
How to change the system date and time from SQL Plus Terminal ?
What is Web service in Blue Prism?
Can a filed occur in several field groups? : abap modularization
what is zuul in spring boot? : Spring Boot
please send me privious exam's queation papers of section engineer(electrical).
why metadb requires a seperate slice to create Solaris volume manager
What are the types of users in business objects?
what is journal import?
Mention what is the meaning of broker in kafka?
What does angie mean?
What are the key functions you can perform under forecasting & replenishment process?
How to create sub reports?
What is your style of management
