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

SELECT employee_id, employee_name, salary FROM employees
where rownum < 6 ORDER BY
salary DESC
group by department_id;

Is This Answer Correct ?    4 Yes 29 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of oracle?

1041


How to rename a column in an existing table?

1048


Explain the use of rows option in imp command.

1094


How can we view last record added to a table?

1052


What is merge statement used for?

1035


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2273


What is the scope of a local variable?

1080


What are the restrictions on external table columns?

1065


What types of joins are used in writing subqueries?

996


What happens if you use a wrong connect identifier?

1082


What are the uses of a database trigger?

1008


How many file formats are supported to export data?

1227


In oracle there is column command, how will you explain that?

1072


Explain oracle 12c new features for developers?

1070


How to run the anonymous block again?

1145