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
- 11577 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha_gupta
select ename,sal from (select rownum rnum ,rowid rid from
emp order by sal desc) a , emp e
where a.rnum = 4
and a.rid= e.rowid
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
default triggers available for reports
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
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.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What is an Oracle database Partial Backup?
What is db_recovery_file_dest in oracle? When do you need to set this value?
What is auto invoicing? Explain : oracle accounts receivable
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
What is the importance of batch source set up in ar? : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
