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
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Give two methods you could use to determine what DDL changes have been made.
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
how to write customizations in po
Can we modify approve purchase order?if yes what is navigation?
Why more redos are generated when the oracle database is in begin backup mode?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
what are the tools used for oracle 10g in real time.
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Explain about party and customer in ar : oracle accounts receivable
3. Steps in UAT?