Wednesday, February 24, 2016

学习SQL

有用经验:
http://www.ezthelife.com/archives/18908

有用的网站

http://www.w3schools.com/


12. With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
You answered:
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
 Wrong Answer!

16. With SQL, how can you insert a new record into the "Persons" table?
You answered:
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
 Wrong Answer!

17. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
You answered:
INSERT ('Olsen') INTO Persons (LastName)
 Wrong Answer!