write a query to find the third maximum salary of a
employee.(table:employ col name:salary)
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
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
Are These Dff's Flexible?
How many segment are present in Oracle Manufacturing
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
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.
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
How would you determine what sessions are connected and what resources they are waiting for?
What is the mandatory setup in cyclecount ?
What is the difference between conversions and interfaces? : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
How to clone the database using RMAN back
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
what are the tools used for oracle 10g in real time.