Uncategorized


Here are some of the Uncategorized articles. If you don't see the answer to your questions about Uncategorized, ask us your question and we will get back with you with an answer.

SQL “Union ALL” vs. “Union”

Sometimes, you might need to get a record set of the UNION of two SELECT’s but you don’t want to remove duplicates.  This might happen if you were just needing a proper count of the rows or if you just wanted to check something before deleting a bunch of rows.

The simple way to do this is with UNION ALL.

A UNION statement returns the UNION of two SELECT’s but removes duplicates.  If you use UNION ALL, the records returned are all the records including duplicates.