As much as I’d like to be able to produce completely error free books, the reality of the computer publishing industry is that the pace at which books must be written and released makes this very difficult. And regretfully, my own books do have sporadic mistakes and typos scattered throughout them.
For the benefit of my readers, here is a current errata for Sams Teach Yourself SQL in 10 Minutes – Third Edition. Feel free to print this page for future reference.
And as always, if you come across errors that I do not know about, please let me know. I’ll make sure they are added to this list, and will try to have them corrected in future reprints.
Original printing (246 pages, published April 1, 2004)
| Page | Location | Correction |
|---|---|---|
| 32 | Tip | First line JTS01 belongs to output block at bottom of previous page. Last two lines of tip text fell out of blue tip box. |
| 44 | First OUTPUT block, prod_id column values: | Should be: BR02 and BR03 |
| 44 | Second OUTPUT block, prod_id column values: | Should be: BR01 BR02 and BR03 |
| 51 | Code snippet in note | Missing trailing ) |
| 52 | Analysis block. | Final line of paragraph is extraneous and should be deleted. |
| 60 | Table 8.2, LTRIM() | The brackets pertaining to Access belong with the previous entry, LOWER() |
| 63 | Second input block: ‘YY’ | Use the full four digit annotation (this is required in some DBMSs, including Oracle): ‘YYYY’ |
| 78 | Last line (before INPUT): So, how do you filter rows? | Should be: So, how do you filter groups? |
| 82 | Caution box, last line: ORDER BY 1 | Should be: ORDER BY 2 |
| 100 | Second to last line: In the next, lesson, | Should be: In the next lesson, |
| 125 | Second note, last line: later | Should be: latter |
| 137 | First caution, words: DB2 requires | Should be: Some DBMSs require |
| 167 | Code block, lines 4 and 8, first VALUES parameter: 20010 | Should be: 20100 |
| 168 | Note, second line: support for views | Should be: support for cursors |
| 177 | Second INPUT block, first line | Should be: ALTER TABLE Orders |
| 183 | Note, second line: still does not support views (support for views | Should be: still does not support triggers (support for triggers |
| 194 | 3rd and 4th bullets, URL to book page. | Should be http://www.forta.com/books/0672325675/ |