Learning SQL --集合操作
A+B A union B
AB A intersect B
A-B A except B
1.union intersect except
SELECT id,gender
FROM student_list
UNION ALL
SELECT id,food
FROM favorite_food;
UNION 去除重复项,union保留重复项
A+B A union B
AB A intersect B
A-B A except B
1.union intersect except
SELECT id,gender
FROM student_list
UNION ALL
SELECT id,food
FROM favorite_food;
UNION 去除重复项,union保留重复项