except、except all 都是取集合的差集; 它们的区别在于except取差集后会删除重复项,而except all 不删除重复项。 下面是举例说明:
表et1
a
--
1
2
3
2
表et2
b
---
1
3
except执行结果:
mybase=# select a from et1 except select b from et2;
a
---
2
(1 行)
except all执行结果:
mybase=# select a from et1 except all select b from et2;
a
---
2
2
(2 行)