SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
/*CATAPANG ALLEN ANGELO*/ CREATE TABLE tblBooks ([ISBN] int, [TITLE] varchar(40), [AUTHOR] varchar(40), [PUBLICATIONYEAR] date, [PRICE] decimal(10,2)) INSERT INTO tblBooks ([ISBN], [TITLE], [AUTHOR], [PUBLICATIONYEAR], [PRICE]) VALUES (1001, 'Anna Karenina', 'Leo Tolstoy', '2008-03-25', 3500.00), (1002, 'To Kill a mockingbird', 'Harper Lee', '2010-07-30', 2750.00), (1003, 'The great gatsby', 'F.Scott Fitzgerald', NULL, 2000.00), (1004, 'One Hundred Years of Solitude', 'Gabriel Garcia Marquez', '2013-02-23', NULL), (1005, 'A Passage to India', 'E.M.Foster', '2009-05-09', 1750.00) SELECT * FROM tblBooks SELECT * FROM tblBooks WHERE PUBLICATIONYEAR = '2005' OR PRICE IS NULL SELECT TITLE, PRICE FROM tblBooks SELECT TOP 3 * FROM tblBooks UPDATE tblBooks SET AUTHOR = 'Tom Cruise' WHERE ISBN = 1003; SELECT * FROM tblBooks;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear