"if you encounter any errors in SAP, send me a screenshot at pramod@learntosap.com, and I will help you resolve the issue."

SQL UNION Operator

SQL TUTORIALS-

SQL UNION Operator

Introduction-

✅In a Simple Word UNION operator is used to combine the result sets of two or more SELECT statements into a single result set...

💡 Note: The SQL UNION Operator. SELECT must have the same number of columns. also Columns must have similar data types.

✅ Syntax Example -



SELECT column1, column2 FROM table1
UNION
SELECT column1, column2 FROM table2;

💡 Note: The SQL UNION Operator. Example of two Table 1)-Employee IND. And 2)-Employee US.

Emoji Examples in HTML

Emoji Examples in HTML



SELECT Name FROM Employees_IND
UNION
SELECT Name FROM Employees_US;

✅Result Show :-

Result →

Emoji Examples in HTML



SELECT Name FROM Employees_IND
UNION ALL
SELECT Name FROM Employees_US;

✅Result Show :-

Result →

Emoji Examples in HTML

1.The UNION operator removes duplicate rows by default.?

Yes No

2.UNION can be used to combine results from different databases.?

No Yes

3.Is it true that a FULL OUTER JOIN shows only matched rows from both tables.?

No Yes