Sams Teach Yourself SQL in 10 Minutes - Third Edition
- ISBN: 0672325675
- Pages: 246
- Publisher: Sams - April 1, 2004
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.
Page 32
Location: Tip
Error: First line JTS01 belongs to output block at bottom of previous page. Last two lines of tip text fell out of blue tip box.
Page 44
Location: First OUTPUT block, prod_id column values:
Error: Should be: BR02 and BR03
Location: Second OUTPUT block, prod_id column values:
Error: Should be: BR01 BR02 and BR03
Page 51
Location: Code snippet in note
Error: Missing trailing )
Page 52
Location: Analysis block.
Error: Final line of paragraph is extraneous and should be deleted.
Page 60
Location: Table 8.2, LTRIM()
Error: The brackets pertaining to Access belong with the previous entry, LOWER()
Page 63
Location: Second input block: 'YY'
Error: Use the full four digit annotation (this is required in some DBMSs, including Oracle): 'YYYY'
Page 78
Location: Last line (before INPUT): So, how do you filter rows?
Error: Should be: So, how do you filter groups?
Page 82
Location: Caution box, last line: ORDER BY 1
Error: Should be: ORDER BY 2
Page 100
Location: Second to last line: In the next, lesson,
Error: Should be: In the next lesson,
Page 125
Location: Second note, last line: later
Error: Should be: latter
Page 137
Location: First caution, words: DB2 requires
Error: Should be: Some DBMSs require
Page 167
Location: Code block, lines 4 and 8, first VALUES parameter: 20010
Error: Should be: 20100
Page 168
Location: Note, second line: support for views
Error: Should be: support for cursors
Page 177
Location: Second INPUT block, first line
Error: Should be: ALTER TABLE Orders
Page 183
Location: Note, second line: still does not support views (support for views
Error: Should be: still does not support triggers (support for triggers
Page 194
Location: 3rd and 4th bullets, URL to book page.
Error: Should be http://www.forta.com/books/0672325675/