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 15069Post 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)
What is an actual parameter?
what is the theoritical percentage of concrete cubes testing per day?
List down the basic characteristics of cloud computing?
what is a .xap file?
How do I make python scripts executable?
google maps - show in map / show route in customer or vendor card?
How can you connect models to a database manually?
What is the difference between responsibility-driven and data-driven approaches?
What technical support do we get with Delphi?
What does disc error mean?
In Quality Center, If we can reuse a non reusable test script as template test, then what is the need of defining reusable test scripts? What additional functionality does Reusable test scripts add when compared to non reusable test scripts?
What are the different types of data type?
What is the difference between jboss and weblogic?
Do you know what are the ways in which actionscript's code can be protected?
What is Other histogram-based operations?
