0

I want to exclude a population of people of about 13,000 participant ID's. SQL will only allow up to 1000 records in the Where or And clause, so i would have to run my query 13 times. I tried the WITH Clause and it didn't exclude them.

longhornbbbb
  • 7
  • 2
  • 1
    You've tagged this for Oracle and Snowflake-- which one are you actually using? Where are these participant IDs coming from? If you are using Oracle and the source is another query, an `IN` clause can have a query that returns as many rows as you'd like. – Justin Cave Nov 02 '20 at 15:57
  • 1
    Store all 13000 ids to exclude in a separate table (maybe a temp one) and perform an anti-join against it. – The Impaler Nov 02 '20 at 16:17

0 Answers0