I have the following snippet of a table that I am trying to filter some identities for:
id fid ts val
44292 1243 2014-12-15 00:00:00.000 True
44292 1243 2017-02-02 00:00:00.000 False
44292 1250 2014-12-16 00:00:00.000 ABC
44293 1243 2014-12-15 00:00:00.000 True
44293 1243 2017-02-02 00:00:00.000 False
44293 1250 2014-12-16 00:00:00.000 KKK
44294 1243 2014-12-15 00:00:00.000 True
44294 1243 2017-02-02 00:00:00.000 False
44295 1243 2014-12-15 00:00:00.000 True
44295 1243 2017-02-02 00:00:00.000 False
What I am trying to do is to filter for id’s that do not have a row for fid = 1250
.
So in the above example, we have id’s 44292, 44293, 44294, 44295, of which only the first two id’s have a row with fid=1250
, whereas id 44294, 44295 do not have such a row.
So I would like to simply return id’s 44292, 44293; is this possible?