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

SQL Server - NULL values with IN and NOT IN

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 14, rows affected: 4, absolute service time: 0,2 sec, absolute service time: 0,21 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 Test 1
   ID val_1 metric
1 3 c 30
   marker
1 Test 2
   marker
1 Test 3
   ID val_1 metric
1 1 a 10
2 2 b 20
   marker
1 Test 4
   ID val_1 metric
1 1 a 10
2 2 b 20