write a query to find the third maximum salary of a
employee.(table:employ col name:salary)
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
Give two methods you could use to determine what DDL changes have been made.
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What are different types of transactions in ar? : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : 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.
how to replace not in with not exist?
as a technical developer in oracle applications which type errors feced in your experience sofar
key flexfield structure
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Where in the Oracle directory tree structure are audit traces placed?
1. What is PO rate variance gain and loss?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
What is the disk migration? what is the steps involved in oracle disk migration?