MariaDB Union All Operator

by Online Tutorials Library July 14, 2022

MariaDB UNION ALL Operator

MariaDB UNION ALL Operator is same as UNION operator but it doesn’t remove the duplicate records. It returns all rows from the query and it does not remove duplicate rows between the various SELECT statements.

Syntax:

 SELECT expression1, expression2, … expression_n FROM tables [WHERE conditions] UNION ALL SELECT expression1, expression2, … expression_n FROM tables [WHERE conditions];  

Note: In MariaDB UNION ALL operator, each SELECT statement must have the same number of fields in the result sets with similar data types.

Return Single Field using UNION ALL Operator

Output:

MariaDB Union all operator 1

You can see that it does not remove duplicate records.

UNION ALL Operator with ORDER BY Clause

Use UNION ALL operator with ORDER BY clause to retrieve multiple columns from both table.

 SELECT student_id, student_name FROM Students WHERE student_name = ‘Komal’ UNION ALL  SELECT student_id, salary FROM Student WHERE student_id > 4 ORDER BY 1; 

Output:

MariaDB Union all operator 2

Next TopicMariaDB Intersect Operator

MariaDB Union All Operator

MariaDB UNION ALL Operator

Note: In MariaDB UNION ALL operator, each SELECT statement must have the same number of fields in the result sets with similar data types.

Return Single Field using UNION ALL Operator

UNION ALL Operator with ORDER BY Clause

System Testing

Bar Graph

You may also like