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

Explain what are clusters?

1113


How to convert times to characters in oracle?

1027


Why packages are used in oracle?

1070


What is memory advisor in Oracle?

1078


What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1119


20. Using a set operator, display the client number of all clients who have never placed an order.

2188


What is flashback in Oracle?

1022


What are the roles of dba?

1070


What is a named program unit?

1088


What is a subquery in oracle?

1112


How to build data dictionary view an new database?

1013


How to convert a date to char in oracle? Give one example.

1069


What the is the diff between local index and global index. give some example.

1642


What is oracle update statement with inner join ?

1065


Explain a private synonyms?

1043