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

Answer Posted / jas

select a.sal,a.emp_no from employee a
where 5=(select distinct(count(*) from
employee b where a.sal> b.sal)

Is This Answer Correct ?    8 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2228

Please explain joins in oracle?

1025

How to use in conditions in oracle?

1015

What are the original export and import utilities?

1095

Explain an exception and its types?

1036

Why use resource manager in Oracle?

1071

What is the dynamic sql in oracle?

1029

What is snapshot is too old? Give and example for better understand.

1561

Name the various constraints used in oracle?

987

Design database draw er diagram for a certain scenario ?

4551

What is an oracle data file?

1061

What do you mean by cdb and pdb in oracle 12c?

1031

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1084

What is the usage of synonyms?

1093

How to convert characters to dates in oracle?

1051