Union All in SQL - sql - sql tutorial - learn sql




Difference Between Union Unionall Except Intersect

Difference Between Union Unionall Except Intersect
  • The SQL UNION ALL operator is used to combine the result sets of 2 or more SELECT statements.
  • It does not remove duplicate rows between the various SELECT statements (all rows are returned).
  • Each SELECT statement within the UNION ALL must have the same number of fields in the result sets with similar data types.
sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorial

Syntax

  • The syntax for UNION ALL is as follows:
[SQL Statement 1]
UNION ALL
[SQL Statement 2];
  • The columns selected in [SQL Statement 1] and [SQL Statement 2] need to be of the same data type for UNION ALL to work.

Anatomy of a Union

Anatomy of a Union

SQL Union All Query

Anatomy of a Union

Example

  • We use the following tables for our example.

Table Store_Information

Store_Name Sales Txn_Date
Los Angeles 1500 Jan-05-1999
San Diego 250 Jan-07-1999
Los Angeles 300 Jan-08-1999
Boston 700 Jan-08-1999

Table Internet_Sales

Txn_Date Sales
Jan-07-1999 250
Jan-10-1999 535
Jan-11-1999 320
Jan-12-1999 750
  • · To find out all the dates where there is a sales transaction at a store as well as all the dates where there is a sale over the internet, we use the following SQL statement:
SELECT Txn_Date FROM Store_Information
UNION ALL
SELECT Txn_Date FROM Internet_Sales;

Result:

Txn_Date
Jan-05-1999
Jan-07-1999
Jan-08-1999
Jan-08-1999
Jan-07-1999
Jan-10-1999
Jan-11-1999
Jan-12-1999

Union vs Union All

Union vs Union All

This tutorial provides more the basic needs and informations on sql tutorial , pl sql tutorial , mysql tutorial , sql server , sqlcode , sql queries , sql , sql formatter , sql join , w3schools sql , oracle tutorial , mysql , pl sql , learn sql , sql tutorial for beginners , sql server tutorial , sql query tutorial , oracle sql tutorial , t sql tutorial , ms sql tutorial , database tutorial , sql tutorial point , oracle pl sql tutorial , oracle database tutorial , oracle tutorial for beginners , ms sql server tutorial , sql tutorial pdf

Related Searches to Union All in SQL

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×