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
- 33391 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sunil panghal
select rownum as row_id,salary from (select salary from
employees order by salary) where rownum <6;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is the difference between translate and replace in oracle?
Explain oracle 12c new features for developers?
What are the numeric comparison operations?
Use of an integrity constraint is better to validate data. Explain
what is the difference between functional dependecy and multilevel dependency?
How to create a new oracle data file?
What is varray?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to view all columns in an existing table?
How to create a testing table in oracle?
What does sharding mean?
How to rename an index?
What is different types of joins?
What is a system tablespace?
