select ename,sal from (select rownum rnum ,rowid rid from emp order by sa

write a query to find the third maximum salary of a
employee.(table:employ col name:salary)

Question Posted / neha_gupta

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

Please Help Members By Posting Answers For Below Questions

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2104

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2281

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2076

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2403

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2328

What is the mandatory setup in cyclecount ?

2756

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1999

as a technical developer in oracle applications which type errors feced in your experience sofar

2192

How to clone the database using RMAN back

2245

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1093

HOW TO SPOT AHIERARCHY?

2301

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2264

how to write customizations in po

1621

What are different types of transactions in ar? : oracle accounts receivable

1301

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1133