Errata
Sams Teach Yourself SQL in 10 Minutes · ISBN 0672336073 · 42 corrections
Initial printing
| Page | Location | Correction |
|---|---|---|
| 19 | Paragraph following the OUTPUT block: 14 products | Should be: 9 products |
| 19 | Paragraph following the OUTPUT block: 14 rows | Should be: 9 rows |
| 20 | Caution block, words: “unless both” | Should be: “because both” |
| 20 | First paragraph, “only four rows” | Should be: only three rows |
| 22 | Second ANALYSIS block, second sentance | Should be: The first number is the number of rows to retrieve, and the second number is where to start. |
| 23 | Bullet at bottom of page, “SQL statement grow” | Should be: SQL statements grow |
| 23 | Tip, second sentence | Should be: “Using this syntax, the value before the , is the OFFSET and the value after the , is the LIMIT.” |
| 23 | TIP | This TIP applies to SQLite as well |
| 24 | Second bullet, words “so that MariaDB” | Should be: “so that the DBMS” |
| 24 | First paragraph after bullets, “We’ll Start” | Should be: We’ll start |
| 24 | First bullet, “at the top of SQL file” | Should be “at the top of the SQL file” |
| 41 | Second INPUT block, “FROM CUSTOMERS” | Should be: FROM Customers |
| 56 | TIP, closing WHERE clause | Should be: WHERE email LIKE ‘b%@forta.com’ |
| 58 | Note, first line: describes | Should be: described |
| 62 | Final paragraph, “The reports wants” | Should be: The report wants |
| 63 | First paragraph, “the three columns” | Should be: the two columns |
| 64 | Third bullet, “state stored” | Should be: country stored |
| 79 | Input block at top of page, 2012 in WHERE clause. | Should be: ‘2012’ |
| 83 | Caution block. | Add the following to the caution. “The exception to this is when returning a single value that is calculated from multiple columns, as will be explained later in this lesson.” |
| 107 | INPUT block, middle SELECT statement: FROM Order | Should be: FROM Orders |
| 109 | Paragraph beginning, “The WHERE clause”, words “column names, instead of” | Should be: column names; instead of |
| 111 | CAUTION block, 5th line, text “if you” | Should be: if your |
| 120 | First paragraph, “as the preceding example” | Should be: as an earlier example |
| 126 | Paragraph beginning “So far”, “You’ll Now take a look at” | Should be: You’ll now look at |
| 127 | Analysis section, last line: “Subqeries” | Should be: Subqueries |
| 131 | CAUTION block, first line, words LEFT OUT JOIN | Should be: LEFT OUTER JOIN |
| 143 | NOTE block, first line | Missing a . after word UNION |
| 164 | First paragraph, third line. “that You” | Should be: that you |
| 183 | Note, “was a rather” | Should be: is rather |
| 199 | Last paragraph, “what transactions processing is” | Should be: what transaction processing is |
| 201 | First paragraph, last line, “undo then” | Should be: undo them |
| 205 | NOTE block, first line, words “does support” | Should be: does not support |
| 210 | INPUT block | ANALYSIS refers to a … placeholder, but it is missing from the code snippet. |
| 215 | First INPUT block, line beginning vend_zip | This line is missing its trailing , character |
| 221 | INPUT block: ON PRODUCTS | Should be: ON Products |
| 230 | Paragraph beginning “The SQL statements”, words “these file” | Should be: these files |
| 235 | Step 2, “available database” | Should be: available databases |
| 241 | Using Oracle section, item 2, words “Before you can any” | Should be: Before you can use any |
| 241 | “Using Oracle” step 1, “using provided” | Should be: using the provided |
| 242 | Using Oracle Express Step 4, “enter and text SQL” | Should be: enter any SQL text |
| 254 | Paragraph beginning “Fixed length”, words “padded with spaces or nulls” | Should be: padded with spaces |
| 263 | TAPE | Should be: TYPE |