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 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


Please Help Members By Posting Answers For Below Questions

Give two methods you could use to determine what DDL changes have been made.

6746


Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1126


What is the use of lockboxes? : oracle accounts receivable

1183


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1028


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

1263


What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1185


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.

2296


how to replace not in with not exist?

3708


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

2168


key flexfield structure

2154


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2090


Where in the Oracle directory tree structure are audit traces placed?

2608


1. What is PO rate variance gain and loss?

2887


what is the link between suppliers and banks in ap module in oracle apps? And also query?

2455


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

1205