Null

Suraj123 · August 06, 2022
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  country TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M','');
INSERT INTO students VALUES (2, 'Joanna', 'F','');
-- fetch some values
SELECT * FROM students WHERE country is null;
Output
(Run the program to view its output)

Comments

Please sign up or log in to contribute to the discussion.