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 14670Post 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 are packages in r?
where can the transformer having vector group Yny0 be used??
What is subtheme?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
You want to link a c++ program to c functions. How would you do it?
How do I charge bank charges on payments to clients
What is difference between @controller and @restcontroller?
How can you setup Database in Django?
Explain the linux ‘cd’ command options along with the description?
What do you understand by unix shell?
Can protocols have properties?
What is a scrollspy plugin in bootstrap?
What do you mean by spring java based configuration?
Which elements of HTML 4.01 are no more a part of HTML5?
What is the current exception in blue prism?
