xxxxxxxxxx
-- INIT database
CREATE TABLE samples (
id INT
,name VARCHAR(100)
);
INSERT INTO samples(id, name) VALUES (1, 'SQL');
INSERT INTO samples(id, name) VALUES (2, 'Python');
INSERT INTO samples(id, name) VALUES (3, 'JavaScript');
INSERT INTO samples(id, name) VALUES (NULL, 'C#');
-- QUERY database
SELECT * FROM samples WHERE id NOT IN (1, 2, NULL);
id | name |
---|
(1 rows affected)
(1 rows affected)
(1 rows affected)
(0 rows affected)