Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to find the third maximum salary of a
employee.(table:employ col name:salary)
- 7 Answers
- 11400 Views
- I also Faced
- E-Mail Answers
Answer Posted / saiprasanna
select max(salary) from employ
where salary=(select max(salary) from employ where salary
<(select max(salary) from employ));
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What do you mean by Oracle MEDIA RECOVERY?
A scenario for amount correction & how to use amount correction functionality in AP invoices
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What Are Cross Validation & Adi?
What is an Oracle database Full Backup?
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.
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
what are basic modules required to implement oracle application in any oraganisation?
What is autocashrule set? : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Explain the use of table functions.
difference of using cursor for loop and open,fetch,close.which one is better
What is an Oracle database Partial Backup?
