SQL
`EXCEPT`
The `EXCEPT` clause can be used to select all rows that **only** occur in the left query.  
#### Vanilla `EXCEPT` (Set Semantics) {#docs:sql:query_syntax:setops::vanilla-except-set-semantics}  
Vanilla `EXCEPT` follows set semantics, therefore, it performs duplicate elimination, so only unique rows are returned.  
```sql
SELECT * FROM range(5) t1(x)
EXCEPT
SELECT * FROM range(2) t2(x);
```  
| x |
|--:|
| 2 |
| 3 |
| 4 |  
#### `EXCEPT ALL` (Bag Semantics) {#docs:sql:query_syntax:setops::except-all-bag-semantics}  
`EXCEPT ALL` uses bag semantics:  
```sql
SELECT unnest([5, 5, 6, 6, 6, 6, 7, 8]) AS x
EXCEPT ALL
SELECT unnest([5, 6, 6, 7, 7, 9]);
```  
| x |
|--:|
| 5 |
| 8 |
| 6 |
| 6 |