Sams Teach Yourself SQL in 21 Days, Fourth Edition

Day 2

Quiz

1:	Do the following statements return the same or different output: SELECT * FROM CHECKS; select * from checks;
A1:	The only difference between the two statements is that one statement is in lowercase and the other uppercase. Case sensitivity is not normally a factor in the syntax of SQL. However, be aware of capitalization when dealing with data.
2:	None of the following queries work. Why not? Select * Select * from checks Select amount name payee FROM checks;
A2:	Select * The FROM clause is missing. The two mandatory components of a SELECT statement are the SELECT and FROM. Select * from checks The semicolon, which identifies the end of a SQL statement, is missing. Select amount name payee FROM checks; You need a comma between each column ...