Darpan

an anonymous user · January 23, 2021 · SQL
-- create a table
CREATE TABLE Doctors (
  name TEXT NOT NULL,
  address TEXT NOT NULL,
  qualification TEXT NOT NULL,
  specialization TEXT NOT NULL
  
);
-- insert some values
INSERT INTO students VALUES ('Nishant', 'Mumbai', 'MBBS', 'Psycology');
INSERT INTO students VALUES ('Aman', 'Delhi', 'MBBS', 'Surgery');
INSERT INTO students VALUES ('Devendra', 'Delhi', 'MBBS', 'Physician');
-- fetch some values
SELECT * FROM students WHERE specialization = 'Psycology';

Comments

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