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
- 33369 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pawan
Select DISTINCT TOP 5 salary from emp_table1
UNION ALL
Select DISTINCT TOP 5 salary from emp_table2
for more details about UNION and UNION ALL check this: http://www.w3schools.com/sql/sql_union.asp
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why packages are used in oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Explain the use of rows option in exp command.
What is the order of defining local variables and sub procedures/functions?
What is a user role 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?
What is pragma autonomous transaction in oracle?
How to check the oracle tns settings?
What is tns service name?
What is a Garbage Collection? and what is full recursive Garbage collection?
6. Display the client name and order date for all orders using the traditional method.
How does Oracle guarantee data integrity of data changes?
What is the relation of a user account and a schema?
What is backup in Oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
