UNION rules
- both queries need t return the same number of columns
- the corresponding columns in the queries must have compatible data types — UNION use:
- removes all duplicate rows unless the UNION ALL is used
- may place the rows in the first query before, after or between the rows in the result set of the second query
- order using ORDER BY
We use cookies to understand our websites traffic and offer our website visitors personalized experience. To find out more, click ‘More Information’. In addition, please, read our
Privacy policy.