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
- 11388 Views
- I also Faced
- E-Mail Answers
Answer Posted / ravindra
select max(sal) from emp where level=3 connect by prior sal>sal;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How would you determine what sessions are connected and what resources they are waiting for?
What is mrc and what is its use? : oracle accounts receivable
what is semphore explian it?
Is there any link between pr form(purchse requisition)and po form(purchase order)
what is difference between inner join & nested query or subqueries
What is the difference between conversions and interfaces? : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
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
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
Are These Dff's Flexible?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
Where in the Oracle directory tree structure are audit traces placed?
