Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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)

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


Please Help Members By Posting Answers For Below Questions

What is autocashrule set? : oracle accounts receivable

1497


what are basic modules required to implement oracle application in any oraganisation?

2257


How to clone the database using RMAN back

2310


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

2234


How many segment are present in Oracle Manufacturing

2370


Explain the process of recievables in oracle financials. : oracle accounts receivable

1202


What is the difference between conversions and interfaces? : oracle accounts receivable

1303


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2261


Can we modify approve purchase order?if yes what is navigation?

2071


What is the importance of batch source set up in ar? : oracle accounts receivable

1318


What is auto invoicing? : oracle accounts receivable

1235


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2125


Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

8011


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1478


What is the disk migration? what is the steps involved in oracle disk migration?

1266