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
- 11280 Views
- I also Faced
- E-Mail Answers
Answer Posted / saiprasanna
select max(salary) from employ
where salary=(select max(salary) from employ where salary
<(select max(salary) from employ));
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
8. Supporting AP, AR and GL?
key flexfield structure
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 is the use of lockboxes? Steps for lock box : oracle accounts receivable
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
please send me oracle pl/sql exp resume. and also faqs...
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
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 are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What is an Oracle database Partial Backup?
as a technical developer in oracle applications which type errors feced in your experience sofar
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
