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
- 11379 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
what is difference between inner join & nested query or subqueries
Where in the Oracle directory tree structure are audit traces placed?
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
How do you create a credit note against an invoice? : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
8. Supporting AP, AR and GL?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Explain the use of table functions.
Are These Dff's Flexible?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
What is auto invoicing? : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
can we use lexical perameter in oracle plsql if yes how
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
