如何通过订单id获取零件id,并且零件没有其他人订购

使用子查询

select * from yourtable a
where order_id = '1'
and part_id not in (select part_id from yourtable where order_id <> a.order_id)

你可以用 NOT EXISTS 以及一个相关子查询,用于检查具有相同部分的其他订单。

SELECT t1.part_id
       FROM elbat t1
       WHERE t1.order_id = '000000000001'
             AND NOT EXISTS (SELECT *
                                    FROM elbat t2
                                    WHERE t2.order_id <> t1.order_id
                                          AND t2.part_id = t1.part_id);