查找同一张表中没有对应记录的记录 [英] Find records that do not have a corresponding record in the same table

问题描述

我有下表:

 ID | JobID | Data   | ResultType
---------------------------------
  1 | 12345 | XXXX   | 0
  2 | 12345 | YYYY   | 1
  3 | 23456 | AAAA   | 0
  4 | 23456 | BBBB   | 1
  5 | 34567 | FOOB   | 0
  6 | 45678 | BARB   | 0

现在我需要构建一个查询来提供所有 JobIDs，其中没有 ResultType = 1

Now I need to build a query that delivers all JobIDs where there is no entry with a ResultType = 1

所以最后，我想要只提供 JobIDs 34567 和 45678 的结果，因为这些 JobIDs 没有 ResultType = 1 的记录.

So at the end, I want to result that delivers only JobIDs 34567 and 45678, because there is no record with a ResultType = 1 for those JobIDs.

有人能指出正确的方向吗?

Can someone point me in the right direction?

推荐答案

另一种方式(未测试):

Another way (not tested):

SELECT JobId FROM Jobs GROUP BY jobId HAVING max(ResultType) = 0

这篇关于查找同一张表中没有对应记录的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！