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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / uttam

Answer Posted / uttam

select sal from (SELECT distinct sal FROM emp order by sal
desc)
where rownum <6

Is This Answer Correct ?    13 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you use check constraints for self referential integrity?

975

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2361

How to do clean up if create database failed?

1035

How to assign values to data fields in record variables?

1039

What is a cursor and what are the steps need to be taken?

1208

Please explain joins in oracle?

1066

How to count duplicated values in a column in oracle?

1052

Explain the difference between sap and oracle?

1038

How to run create database statement?

1040

How to write a query with an inner join in oracle?

1048

Is postgres faster than oracle?

1048

What is a package in oracle?

1111

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

1122

How to select an oracle system id (sid)?

1069

What is the sql query to concatenate column values from multiple rows in oracle?

1065