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
- 11277 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
What is the mandatory setup in cyclecount ?
How to clone the database using RMAN back
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
where the dff data will be stored
Is there any link between pr form(purchse requisition)and po form(purchase order)
as a technical developer in oracle applications which type errors feced in your experience sofar
default triggers available for reports
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
what are the API of GL,PO,AP
What is the use of lockboxes? : oracle accounts receivable
3. Steps in UAT?
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 an Oracle database Full Backup?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
