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.
- 22 Answers
- 32892 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How do you bind variables in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is oracle in java?
What privilege is needed for a user to connect to oracle server?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Whether any commands are used for months calculation? If so, what are they?
How to assign query results to variables?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to create an oracle database manually?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is the difference between translate and replace?
what are actual and formal parameters?
How to create a single index for multiple columns?
How to omit columns with default values in insert statement in oracle?
