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
- 31961 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shareef
select * from(select emp.*,
dense_rank() over(partition by deptno order by sal desc) r
from emp) where r<=5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain implicit cursor.
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
what are the advantages of running a database in archive log mode?
interview questions with answer for cts
candidate key is subset of super key but not vice-verse explain
What do you understand by a database object? Can you list a few of them?
Explain mutating triggers.
What are the differences between lov and list item?
How to convert a date to char in oracle? Give one example.
How to set up autotrace for a user account?
What is an oracle user role?
What is the difference between hot backup and cold backup in oracle?
What is system tablespace?
How to get a list of all user accounts in the database?
What is the string concatenation operator in oracle?
