Answer Posted / 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.

Explain about various levels of constraint.

907

---

what are all types of user defined functions? : Sql dba

1015

---

What are the advantages of sql? Explain

1069

---

What is normalization in a database?

1125

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

949

---

What is sql character function?

1026

---

Can you join a table to itself?

1069

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1292

---

What is inner join in sql?

1023

---

where are cookies actually stored on the hard disk? : Sql dba

997

---

what is the difference between a local and a global temporary table? : Sql dba

1026

---

Why is sql better than hql?

939

---

Is left join same as join?

954

---

What is the purpose of design view?

969

---

What are analytic functions in sql?

996

---