How to use UNION in SQL || Understanding about UNION Operator in SQL || SQL Union || SQL

In this course we will talk about the use of UNION Operator in SQL

UNION:
The UNION operator is used to combine the result-set of two or more SELECT statements.
Each SELECT statement within UNION must have the same number of columns
The columns must also have similar data types
The columns in each SELECT statement must also be in the same order

UNION Syntax:
SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;

SQL Query:
SELECT
'Customer-01' AS Customer

UNION

SELECT
'Customer-02' AS Customer

UNION

SELECT
'Customer-02' AS Customer
---------------------------
SELECT
500.00 AS MobileBill
, 500.00 AS MonthlyFoodAllowance
UNION
SELECT
600.00 AS MobileBill
, 460.00 AS MonthlyFoodAllowance
UNION
SELECT
200.00 AS MobileBill
, 250.00 AS MonthlyFoodAllowance

Searchable keywords
How to use UNION in SQL
union in sql example
union all in sql
sql union with different columns
sql union multiple tables
intersect in sql
how to combine two select queries in sql with different columns
union and union all in sql
how to combine two sql queries in one result without union
union sql
how to use intersect in sql
How does union work in SQL?
How to use union in SQL with example?
How do you do a union in SQL query?
How to join 2 SQL queries?
union in sql example
sql union with different columns
union all in sql
how to combine two sql queries in one result without union
sql union order by
union in mysql
how to combine two select queries in sql with different columns
sql join
SQL Tutorial - UNION ALL
QL Union and Union All - SQL Training Online - Quick Tips
SQL SERVER UNION QUERY EXAMPLE
Operators in SQL | Union | Union All | Intersect | Except or Minus | Examples | SQL Tutorial
Difference Between Union and Union all SQL Server Tutorial Example
sql intersect
sql except
sql group by
rename operations
sql joins
exists sql
cartesian product
set operations
unique on
MySQL UNIONS are easy
What is the difference between UNION and UNION All ( SQl server )?
MySQL UNION & UNION ALL Tutorial in Hindi / Urdu
SQL Tutorial #36 - SQL UNION Operator | UNION vs UNION ALL in SQL
Combine SQL Queries With UNION, INTERSECT, EXCEPT
SQL UNION and SQL UNION ALL | How to Combine the result sets of 2 or more SELECT statements in SQL
QL Set Operator | union, union all, intersect and minus operator | oracle database
SQL SELF JOIN | UNION & UNION ALL in SQL | SQL Tutorial in Hindi 12
SQL | Union Vs Union ALL | Which has better performance?

@rejawebs @MSSQLDBAsLife @Microsoft @MSSQLBI_Tutorial @tsqlssis7932 @SQL @sqlquery @sqlquery4042 @sqlinsertdeleteupdate @Amit.Thinks @biwithmina7066 @Programming Only @playwithcode @mycodingproject43

Hash Tags
#sql #sqlserver #sqlsubquery #mssqlserver #microsoft #sqltips #sqlinsertdeleteupdate
#how_to_use_union_in_sql
#union_in_sql_example
#union_all_in_sql
#sql_union_with_different_columns
#sql_union_multiple_tables
#intersect_in_sql
#how_to_combine_two_select_queries_in_sql_with_different_columns
#union_and_union_all_in_sql
#how_to_combine_two_sql_queries_in_one_result_without_union
#union_sql
#how_to_use_intersect_in_sql
#how_does_union_work_in_sql?
#how_to_use_union_in_sql_with_example?
#how_do_you_do_a_union_in_sql_query?
#how_to_join_2_sql_queries?
#union_in_sql_example
#sql_union_with_different_columns
#union_all_in_sql
#how_to_combine_two_sql_queries_in_one_result_without_union
#sql_union_order_by
#union_in_mysql
#how_to_combine_two_select_queries_in_sql_with_different_columns
#sql_join
#sql_tutorial_-_union_all
#ql_union_and_union_all_-_sql_training_online_-_quick_tips
#sql_server_union_query_example
#operators_in_sql_|_union_|_union_all_|_intersect_|_except_or_minus_|_examples_|_sql_tutorial
#difference_between_union_and_union_all_sql_server_tutorial_example
#sql_intersect
#sql_except
#sql_group_by
#rename_operations
#sql_joins
#exists_sql
#cartesian_product
#set_operations
#unique_on
#mysql_unions_are_easy
#what_is_the_difference_between_union_and_union_all_(_sql_server_)?
#mysql_union_&_union_all_tutorial_in_hindi_/_urdu
#sql_tutorial #36_-_sql_union_operator_|_union_vs_union_all_in_sql
#combine_sql_queries_with_union,_intersect,_except
#sql_union_and_sql_union_all_|_how_to_combine_the_result_sets_of_2_or_more_select_statements_in_sql
#ql_set_operator_|_union,_union_all,_intersect_and_minus_operator_|_oracle_database
#sql_self_join_|_union_&_union_all_in_sql_|_sql_tutorial_in_hindi_12
#sql_|_union_vs_union_all_|_which_has_better_performance?