What is the sql query to find the employee who has Nth
maximum salary?
Answer Posted / naweed ahmad
SELECT * FROM Emp E1 WHERE n-1 =
(SELECT COUNT(DISTINCT Sal) FROM Emp E2 WHERE E1.Sal <
E2.Sal)order by Sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
How would you determine what sessions are connected and what resources they are waiting for?
Difference between transaction type and transaction sources. : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
A scenario for amount correction & how to use amount correction functionality in AP invoices
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
Can we modify approve purchase order?if yes what is navigation?
as a technical developer in oracle applications which type errors feced in your experience sofar
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
as a technical developer in oracle applications which type errors feced in your experience sofar
Explain how to close periods in ar. : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
how to write customizations in po