Translate to Tamil

Best Offers

Bigbasket [CPS] IN

Amazon Best Offers

Amazon Offers

Offers

Online Income

Best Online Offers

Wikipedia

Search results

Wednesday, 5 January 2011

What is the difference between UNION and UNION 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 the tables fitting your query specifics and combines them into a table.

 Share This Post


No comments:
Write comments

Infolinks

Services

© 2014