Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 14128 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / haroon nazir.s
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 1 : First,Second,Third,Fourth,Fifth
Table 2 : First,Second,Fifth,Sixth
Result Set:
UNION: First,Second,Third,Fourth,Fifth,Sixth (This will
remove duplicate values)
UNION ALL:
First,First,Second,Second,Third,Fourth,Fifth,Fifth,Sixth,Sixth
(This will repeat values)
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is a mixed extent?
What is transact-sql ddl trigger?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
How to manipulate data from one table to another table ?
What is server-level principal?
What are the different acid properties?
What is inner join? Explain with an example?
How to count groups returned with the group by clause in ms sql server?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Can binary strings be used in arithmetical operations?
Does group by sort data?
What happens when unicode strings concatenate with non-unicode strings?
What is 4nf in normalization form?
Why are views required in the sql server or in any other database?
Explain about nested stored procedure?
