Tuesday, 10 April 2012

UNION ALL operator in SQL

The UNION ALL returns results from both queries with duplications.
It will combine the output of two or more queries.

Syntax:
<Component query >
UNION ALL
<Component query>

Keypoints:
Output is not sorted by default.

No comments:

Post a Comment

Do you want to comment