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
- 11117 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 do you mean by hz_ in customer tables? : oracle accounts receivable
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What is the mandatory setup in cyclecount ?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Explain the use of table functions.
3. Steps in UAT?
What is mrc and what is its use? : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Explain about party and customer in ar : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?
1. What is PO rate variance gain and loss?
Are These Dff's Flexible?
