/* 011- IN ( used insted of and,and make it big ) */
-- create table and Insert Records
CREATE TABLE tOne(
id INT NOT NULL UNIQUE,
name VARCHAR(50) NOT NULL,
age INT NOT NULL CHECK(age >= 18),
gender VARCHAR(1) NOT NULL,
phone VARCHAR(10) NOT NULL UNIQUE,
city VARCHAR(15) NOT NULL DEFAULT 'Agra'
);
-- enter the data
INSERT INTO tOne(id,name,age,gender,phone,city)
VALUES
(1,"Ram Kumar","23","M","4022155","Agra"),
(2,"Sarita Kumari","21","F","4034421","Delhi"),
(3,"Salman Khan","20","M","4056221","Agra"),
(4,"Juhi Chawla","28","F","4022156","Bhopal"),
(5,"Anil Kapoor","22","M","4025221","Agra"),
(6,"John Abraham","21","M","4056776","Delhi");
-- IN & NOT IN
SELECT * FROM tOne WHERE age IN(18,21);
SELECT * FROM tOne WHERE age IN(18,21,19);
SELECT * FROM tOne WHERE age NOT IN(18,21,19);
SELECT * FROM tOne WHERE city IN("Delhi","Bhopal");
SELECT * FROM tOne WHERE city NOT IN("Delhi","Bhopal");
SELECT * FROM tOne WHERE id IN(1,3,4);