/* 017 LIMIT & OFFSET (need to see the data in limited form ) */ -- create table 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' ); -- insert records 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"), (7,"Shahid Kapoor","20","M","4022784","Agra"); -- Limit SELECT * FROM tOne LIMIT 2; -- starting two values SELECT * FROM tOne LIMIT 3; SELECT * FROM tOne WHERE city = "Agra" LIMIT 3; SELECT * FROM tOne WHERE city = "Agra" ORDER BY name LIMIT 3; -- Offset SELECT * FROM tOne LIMIT 3, 3; -- leave starting 3 entry and start showin after 3 entry SELECT * FROM tOne LIMIT 6, 3; SELECT * FROM tOne LIMIT 0, 3;