/* 015 - ORDER BY & DISTINCT */ -- 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"); -- ORDER BY SELECT * FROM tOne ORDER BY name; -- alphabetic order SELECT * FROM tOne ORDER BY name DESC; -- descending order SELECT * FROM tOne WHERE city = "Agra" ORDER BY name DESC; -- WHERE, ORDER BY, DESC SELECT * FROM tOne WHERE city = "Agra" ORDER BY name; -- WHERE, ORDER BY, DESC SELECT * FROM tOne ORDER BY age; -- order by using numbers SELECT * FROM tOne ORDER BY city; SELECT * FROM tOne ORDER BY name,city; -- multiple order -- DISTINCT ( show only unique values , no duplicate ) SELECT DISTINCT city FROM tOne; SELECT DISTINCT age FROM tOne; SELECT DISTINCT age FROM tOne ORDER BY age;