--union求并集,公共部分只有包含一次--union:求emp表ename中含’A‘或含有‘M’SELECT*FROM EMP
WHERE ENAME LIKE'%A%'UNIONSELECT*FROM EMP
WHERE ENAME LIKE'%M%';--union all:公共部分只有包含二次--求emp表ename中含’A‘或含有‘M’SELECT*FROM EMP
WHERE ENAME LIKE'%A%'UNIONALLSELECT*FROM EMP
WHERE ENAME LIKE'%M%';--intersect求交集,只有包含公共部分--求emp表ename中即含’A‘又含有‘M’SELECT*FROM EMP
WHERE ENAME LIKE'%A%'INTERSECTSELECT*FROM EMP
WHERE ENAME LIKE'%M%';--minus求差集,求集合A去除集合A和集合B的交集--求emp表sal从700到1200SELECT*FROM EMP
WHERE SAL BETWEEN700AND1300
MINUS
SELECT*FROM EMP
WHERE SAL BETWEEN1200AND1400;