跳到主要内容

Union

Syntax​

select_statement
UNION [ ALL ]
select_statement

Example​

SELECT * FROM (
	SELECT * FROM user WHERE id < 10
	UNION ALL
	SELECT * FROM user WHERE id > 15
);

SELECT * FROM (
	SELECT * FROM user WHERE id < 10
	UNION
	SELECT * FROM user WHERE id > 15
);

SELECT * FROM (
	SELECT * FROM user WHERE id % 3 = 0
	UNION ALL
	SELECT * FROM user WHERE id % 3 = 1
	UNION ALL
	SELECT * FROM user WHERE id % 3 = 2
);