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
- 11588 Views
- I also Faced
- E-Mail Answers
Answer Posted / jithendranath.g
SELECT Z2.SAL FROM EMP Z1,EMP Z2
WHERE
Z2.SAL <=Z1.SAL
GROUP BY Z2.SAL
HAVING COUNT(Z2.SAL)=3
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is mrc and what is its use? : oracle accounts receivable
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
Could you please let me know the interfaces in OM / FA??
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
8. Supporting AP, AR and GL?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What is the mandatory setup in cyclecount ?
