sql - 以下情况的选择语句

Question

|   Column id         |     status       |
|          1          |      Accept      |
|          1          |     Shipped      |
|          1          |     Received     |
|          2          |      Accept      |
|          2          |     Received     |
|          3          |      Accept      |
|          3          |     Shipped      |
|          3          |     Received     |

我想要那些状态尚未发货但已收到的输出中的 ID。（未发货但已收到）（id 2）

标签： sqloracle

Answer 1

希望这可以帮助：

select column_id
from table
where status = 'Received'
minus
select column_id
from table
where status = 'Shipped'