Drizzle TeamDT
Drizzle Team•3y ago
ccabd

Find IDs from a list which do not exist in table

As the title says, i'm trying to filter a list of given IDs (could be hundreds) into a list of IDs that do not exist in a table (could have multiple thousands of rows).
My research suggests that I should be doing something like this:

select *
from ( 
   values (1),(2),(3)
) as temp(id)
where not exists (select *
                  from mytable
                  where mytable.id = temp.id);


Would you agree and more importantly, can I do this using ORM syntax?

Thanks for any tips or insights you can provide.
Was this page helpful?