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.
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.
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
Location: Code snippet in note
Error: Missing trailing )
Location: Analysis block.
Error: Final line of paragraph is extraneous and should be deleted.
Location: Table 8.2, LTRIM()
Error: The brackets pertaining to Access belong with the previous entry, LOWER()
Location: Second input block: 'YY'
Error: Use the full four digit annotation (this is required in some DBMSs, including Oracle): 'YYYY'
Location: Last line (before INPUT): So, how do you filter rows?
Error: Should be: So, how do you filter groups?
Location: Caution box, last line: ORDER BY 1
Error: Should be: ORDER BY 2
Location: Second to last line: In the next, lesson,
Error: Should be: In the next lesson,
Location: Second note, last line: later
Error: Should be: latter
Location: First caution, words: DB2 requires
Error: Should be: Some DBMSs require
Location: Code block, lines 4 and 8, first VALUES parameter: 20010
Error: Should be: 20100
Location: Note, second line: support for views
Error: Should be: support for cursors
Location: Second INPUT block, first line
Error: Should be: ALTER TABLE Orders
Location: Note, second line: still does not support views (support for views
Error: Should be: still does not support triggers (support for triggers
Location: 3rd and 4th bullets, URL to book page.
Error: Should be http://www.forta.com/books/0672325675/