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

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

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

What is meant by an index?

1078


What is the difference between translate and replace?

1024


What are the set operators union, union all, minus & intersect meant to do?

952


Can we insert data in view oracle?

980


Is there any function in oracle similar like group_concat of mysql?

1007


How do you bind variables in oracle?

945


How to revoke create session privilege from a user in oracle?

977


Can we call procedure inside function in oracle?

1039


How do I connect to oracle?

992


How do I uninstall oracle 11g?

1066


Explain about the analyze command in oracle?

1014


Give the advantages and disadvantages of clusters.

1011


What is the usage of save points in oracle database?

927


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2112


What is save point in oracle database?

1259