Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

SQL Server - NULL values with IN and NOT IN (Solution)

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 16, rows affected: 6, absolute service time: 0,25 sec, absolute service time: 0,26 sec 
edit mode |  history  | discussion
   marker
1 Show All Data
   ID val_1 metric
1 1 a 10
2 2 b 20
3 3 c 30
4 4 NULL 40
   marker
1 Solution 1
   ID val_1 metric
1 3 c 30
2 4 NULL 40
   marker
1 Solution 2
   ID val_1 metric
1 3 c 30
2 4 NULL 40
   marker
1 Solution 3
   ID val_1 metric
1 3 c 30
2 4 NULL 40
   ID val_1 metric
1 1 a 10
2 2 b 20