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

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.

Question Posted / gettosrinivas

22 Answers
33383 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

Answer / lakshya

SELECT salary FROM employee where rownum < 6 ORDER BY
salary DESC
group by dept;

Is This Answer Correct ?

11 Yes

39 No

Post New Answer

More Oracle General Interview Questions

List out the difference between commit, rollback, and savepoint?

Is oracle the best database?

Is oracle a relational database?

6. Display the client name and order date for all orders using the traditional method.

0 Answers Wipro,

What is the difference between a user and a schema in oracle?

Explain coalesce function?

Explain what are the uses of rollback segment?

How to experiment a data lock in oracle?

How do we get field details of a table?

What is an oracle user role?

How would you design a database for an e-commerce website?

How to start your 10g xe server?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)