Advertisements
As an example I have a table in SQL Server :
| Id |
|---|
| 1 |
| 3 |
| 5 |
and I have a list of values 1,2,3
What is the query to select values of my list not in the table.
Expected result :
| Id |
|---|
| 2 |
>Solution :
Here are two approaches
Using Not Exists
Select *
from string_split('1,2,3',',') A
Where not exists ( select 1 from YourTable where ID=Value )
Using a LEFT JOIN
Select A.Value
from string_split('1,2,3',',') A
left Join YourTable B on A.value=B.ID
Where B.ID is null
Both Results are
Value
2