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

What are the restrictions in a oracle read only transaction?

1039

---

Is insert autocommit in oracle?

1070

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2147

---

What is analyze command used for?

1078

---

What is the difference between count (*), count (expression), count (distinct expression)?

1012

---

What is the difference between a primary key & a unique key?

1090

---

How to use in conditions in oracle?

1058

---

Point the difference between translate and replace?

1095

---

How to display row numbers with the records?

1082

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1109

---

What types of joins are used in writing subqueries?

986

---

How do I uninstall oracle client from windows?

1012

---

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1843

---

Compare and contrast between sql and sql server and explain its various functions?

968

---

How to filter out duplications in the returning rows using oracle?

1018

---