学习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!