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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

how will I find the first 5 highest salaried employees in
each dept in oracle.

Question Posted / uttam

Answer Posted / uttam

select sal from (SELECT distinct sal FROM emp order by sal
desc)
where rownum <6

Is This Answer Correct ?    13 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is oracle a language?

900

How to resolve name conflicts between variables and columns?

982

What is the difference between postgresql and oracle?

980

How to pass a cursor variable to a procedure?

1042

What is the sid in oracle?

900

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1981

What is a nvl function?

958

how to clone 9i Database on to 10g Database.

2287

How many memory layers are in the oracle shared pool?

1107

Explain the use of grant option in imp command.

959

How do we represent comments in oracle?

1003

What is an external table?

959

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

978

Does facebook use oracle?

981

How to define a record variable to store a table row?

1005