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

How to assign values to data fields in record variables?

992

---

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1824

---

Difference between pre-select and pre-query

1062

---

How to assign data of the deleted row to variables?

1030

---

Where are the settings stored for each instance in oracle?

1081

---

How to run create database statement again?

1105

---

How to grant create session privilege to a user in oracle?

964

---

How to define an explicit cursor in oracle?

1002

---

How to assign query results to variables?

1027

---

How to define an oracle cursor variable?

992

---

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?

2419

---

What are nested tables?

1129

---

What is redo log?

1022

---

Can we connect to ORACLE db using Windows Authentication?

1205

---

How many anonymous blocks can be defined?

1132

---