交集與除外

• 交集用INTERSECT

select name from main where sex ='女性'

INTERSECT

select name from main where name like '陳%';

• 除外用 EXCEPT
• select name from main where sex ='女性'
• except
• select name from main where name like '陳%';