SQL getting items not in a list
In the bellow example, getting list of person id not exist in the given list
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SELECT E.person_id FROM (VALUES (661), (1826), (2036), (2567), (2922), (3408) ) E(person_id) WHERE NOT EXISTS ( SELECT 1 FROM persontable P WHERE E.person_id = P.id ) |
For strings (varchars)
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
SELECT E.email FROM (VALUES ) E(email) WHERE NOT EXISTS ( SELECT 1 FROM person P WHERE E.email = P.emailid ) |
tested in PostgreSQL