UNIONALL

<< Click to Display Table of Contents >>

Navigation:  Glossary >

UNIONALL

Previous pageReturn to chapter overviewNext page

A relational operator that combines all rows from two queries. Unlike UNION, the expression (A UNION ALL B) does not discard duplicates. UNION ALL can be applied to a streaming query - resulting in all rows from both streams being in the result.