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
- 32312 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nagaraju nampally
select * from (select ename,sal,deptno,dense_rank()
over(partition by deptno order by sal)rnk from emp)x where
x.rnk<5
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
List out the difference between commit, rollback, and savepoint?
What is the relation of a user account and a schema in oracle?
Which is better Oracle or MS SQL? Why?
What is set verify off in oracle?
Explain the use of control file?
Why do we need oracle client?
if you ctreate table identity
What are the limitations of check constraint?
What is BBED in Oracle?
Can you create a synonym without having a table?
How do I connect to oracle database?
What is connection pool in oracle?
What is a subquery in oracle?
How to execute the package in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
