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
- 32826 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rammohan
select rownum as row_id,sal from (select sal from
emp order by sal desc) where rownum <6;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain the use of file option in exp command.
What is a sub query? Describe its types?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to see free space of each tablespace?
How many memory layers are in the oracle shared pool?
How to load excel data sheet to oracle database
When do I need to use a semicolon vs a slash in oracle sql?
What are the data types in oracle?
Can we protect our pl/sql source code?
What happens to the current transaction if the session is killed?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is the difference between sharding and replication?
How many types of auditing in Oracle?
What are the limitations of check constraint?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
