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, Nitin5 10593
1.WHAT IS A SMART CAPABLE DB ( DISTRIBUTION BOX) ? 2. HOW TO DECIDE THE TYPE OF DB TO BE USED ( RECESSED/ PLUG TYPE/ SMART ETC ETC? 3. WHAT IS MILLENEUM BUS BAR USED IN DB? 4.DIFFERENTIATE MCCB AND MCB.
What is the use of paging in operating system?
why are measure gas flow " ml " in Gas chromatography
Explain what is valet?
How can you navigate to see the error idocs?
Why actionservlet is singleton in struts?
Name the different types of checkpoints?
What is python shell scripting?
which osi layer consists of characteristics like acknowledgement, flow control and sequencing?
What is slt?
How do you bold a cell in excel?
Can I use the same windows 10 key on two computers?
What is unicode full form?
What are pre-processor elements? List some of the elements.
what are the different types of fact structures?