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
- 11401 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
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is the mandatory setup in cyclecount ?
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?
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?
please send me oracle pl/sql exp resume. and also faqs...
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is an Oracle database Partial Backup?
HOW TO SPOT AHIERARCHY?
Differentiate between transaction type and transaction source? : oracle accounts receivable
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
which one is currently in used software cmpanies.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
Explain the payment term in ar. : oracle accounts receivable
How to clone the database using RMAN back
