#union opearator

[sqlserverlog]

SQL UNION Operator

  SQL UNION operator is used to combine the results of two or more SELECT statements. Each SELECT statement within the UNION must have the same number of columns and all columns should have same order with similar data types.

  Syntax

SELECT column1, column2, column3,…columnN FROM tableName1 UNION SELECT column1, column2, column3,…columnN FROM tableName2

Here is our first table Student.

We have…

View On WordPress