how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 26985 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / uttam
select sal from (SELECT distinct sal FROM emp order by sal
desc)
where rownum <6
| Is This Answer Correct ? | 13 Yes | 15 No |
Post New Answer View All Answers
What is the difference between formal parameters and actual parameters?
What is the sql query to concatenate column values from multiple rows in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to create a new view in oracle?
How to create a testing table in oracle?
How to run the anonymous block again?
Explain what are the different type of segments?
How do you bind variables in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Point the difference between translate and replace?
Explain enable novalidate constraint.
How to change program global area (pga) in oracle?
Can you drop an index associated with a unique or primary key constraint?
Explain coalesce function?
What is a connect identifier?
