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
- 11286 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
difference of using cursor for loop and open,fetch,close.which one is better
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
What is supporting issues GL AP and AR?
HOW TO SPOT AHIERARCHY?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
Explain about party and customer in ar : oracle accounts receivable
1. What is PO rate variance gain and loss?
What is auto invoicing? Explain : oracle accounts receivable
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
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
How would you determine who has added a row to a table?
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
how to write customizations in po
