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
How do you create a credit note against an invoice? : oracle accounts receivable
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
what are the API of GL,PO,AP
What is mrc and what is its use? : oracle accounts receivable
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Explain the use of table functions.
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
Is there any link between pr form(purchse requisition)and po form(purchase order)
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
What is Tax Categories?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?