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 15200Post 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 difference between static and final in php?
what will join in my company?
What are the major challenges of the High Tech and Insurance industry?
What is the current version of windows 10?
Draw the equivalent circuit of triac and diac.
What is the type of the following Array?, val arr = arrayOf(1, 2, 3);
What sort of existing documents should business analysts refer to when starting on a new project?
Tell me what are your long term career goals?
What is your husband doing?
How do you integrate Generative AI models with existing enterprise systems?
Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com
Tell me about user acceptance testing?
I want single line diagram for AMF & DG syncronizing panel
please anyone can help me in giving dumps in ISTQB for foundation level
does anyone have qtp11.0 license key.Please sendit to my mail id-rrvv2011@gmail.com...Thanks
