Answer / soubhagya

Union:
It retrieves only distinct records.

Union all:
This retrieves duplicate records too.

but in performance issue
unioun all is better becoz it doesnot sort, filter the
record so its faster.

Answer / srinivas

Another difference is that union will sort the result sets
whereas union all will not.

Answer / vibha kant pandey

Hi friends check it this may help you all.

UNION
The UNION command is used to select related information from
two tables, much like the JOIN command. However, when using
the UNION command all selected columns need to be of the
same data type. With UNION, only distinct values are selected.

UNION ALL
The UNION ALL command is equal to the UNION command, except
that UNION ALL selects all values.

The difference between Union and Union all is that Union all
will not eliminate duplicate rows, instead it just pulls all
rows from all tables fitting your query specifics and
combines them into a table.

A UNION statement effectively does a SELECT DISTINCT on the
results set. If you know that all the records returned are
unique from your union, use UNION ALL instead, it gives
faster results.

Example :-
Table X contain values(a,b,c) and Table Y
contain values(c,d,e)
In Case Of Union we will get Result-a,b,c,d,e
and other hand (Union All ) we will get-a,b,c,c,d,e.

Answer / leena

union all will combine the outputs of two or more queries.
union will combine the outputs of two or more queries but remove or ignore duplicate value in output.
union all is most faster as compare to union

What are %type and %rowtype for?

0 Answers  

---

How do you write a subquery?

0 Answers  

---

Why we use joins in sql?

0 Answers  

---

what is self-join? : Sql dba

0 Answers  

---

What are the types of variables use in pl sql?

0 Answers  

---

---

What are local and global Indexes and where they are useful.

0 Answers  

---

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

---

how do you control the max size of a heap table? : Sql dba

0 Answers  

---

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

---

What is view? Can we update view

0 Answers  

---

What is a temp table?

0 Answers  

---