Jimmy Lu songyunlu

Principal Software Engineer @DigitalRiverInc. #SMACK, #Kubernetes, #Cloud, #Microservices. I ♥ #DistributedSystems.

songyunlu / UNION.sql

Last active December 14, 2015 08:19

	SELECT * FROM opp WHERE phone = '1234567' or cellPhone = '7654321';
	/* 改寫為 */
	SELECT * FROM opp WHERE phone = '1234567'
	UNION
	SELECT * FROM opp WHERE cellPhone = '7654321';