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

What is an Oracle Instance?

Why do you create or replace procedures rather that drop and recreate.

How to filter out duplications in the returning rows using oracle?

How can I create database in oracle?

Why does Oracle not permit the use of PCTUSED with indexes?

How to use select statement to count the number of rows in oracle?

what is the syntax of DROP command?

What is truncate oracle?

Explain how are indexes update?

Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.

Explain the use of parfile option in exp command.

How can we view last record added to a table?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1809)
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)