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
- 31964 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
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to load data from external tables to regular tables?
Explain constraining triggers.
Explain an index segment?
How to create a testing table in oracle?
How many types of database triggers exist?
What is the difference between online and offline backups?
What happens to the current transaction if the session is killed?
What are the major difference between truncate and delete?
What is the Tune Query
How a tablespace is related to data files?
How to write a query with a right outer join in oracle?
Explain the types of exception?
What are the attributes that are found in a cursor?
Explain about functional dependency and its relation with table design?
