how will I find the first 5 highest salaried employees in
each dept in oracle.
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
How to define a procedure inside another procedure?
What is oracle used for?
How to select some columns from a table in oracle?
What is the data type of dual table?
How to get execution statistics reports on query statements?
What is an oracle table?
How will you differentiate between varchar & varchar2?
What is the sid in oracle?
What is the implicit cursor in oracle?
List the various oracle database objects?
How can we find out the current date and time in oracle?
What do you know about normalization? Explain in detail?
Explain a segment?
How to convert character types to numeric types?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.