Help Center/ Distributed Database Middleware/ User Guide (ME-Abu Dhabi Region)/ SQL Syntax/ DML/ SELECT UNION Syntax
Updated on 2022-02-22 GMT+08:00
View PDF
Share

SELECT UNION Syntax

Common Syntax

SELECT ...UNION [ALL | DISTINCT] 
SELECT ...[UNION [ALL | DISTINCT] SELECT ...]

Example

select userid from user union select orderid from ordertbl order by userid;
select userid from user union (select orderid from ordertbl group by orderid) order by userid;

Syntax Restrictions

SELECT statements in UNION do not support multiple columns with the same name.

Parent topic: DML