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
- 11284 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha_gupta
select e.ename,a.sal from (select sal, rownum rnum ,rowid
rid from (select * from emp order by sal desc)) a , emp e
where a.rid= e.rowid
and a.rnum = 3
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
What view would you use to determine free space in a tablespace?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
which one is currently in used software cmpanies.
difference of using cursor for loop and open,fetch,close.which one is better
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
A scenario for amount correction & how to use amount correction functionality in AP invoices
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
how to write customizations in po
what are the tools used for oracle 10g in real time.
