SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Age_Table (`ID` int, `First_Name` varchar(10), `Age` int) ; INSERT INTO Age_Table (`ID`, `First_Name`, `Age`) VALUES (2, '"Gary"', 25), (3, '"Bob"', 35), (4, '"Bill"', 22), (5, '"Jill"', 26), (6, '"Todd"', 28), (7, '"Tim"', 31), (8, '"Mary"', 32), (9, '"Cindy"', 32), (10, '"Cathy"', 36), (11, '"Greg"', 29), (12, '"Tina"', 25), (13, '"Harry"', 30), (14, '"Bert"', 24), (15, '"Kim"', 26), (16, '"Rollo"', 42), (17, '"Svet"', 22), (18, '"Melissa"', 29), (19, '"Cindy"', 21), (20, '"Roger"', 32) ; select * FROM Age_Table WHERE Age > 30 ORDER BY Age ASC
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear