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
- 11580 Views
- I also Faced
- E-Mail Answers
Answer Posted / suresh
Select emp.*,dense_rank()over(order by sal desc) rn from emp
where rn=3;
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Where in the Oracle directory tree structure are audit traces placed?
Differentiate between transaction type and transaction source? : oracle accounts receivable
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
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
where the dff data will be stored
Explain prerequisites and post activities of oracle database installation
How would you go about increasing the buffer cache hit ratio?
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?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
please send me oracle pl/sql exp resume. and also faqs...
