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

Back to Book Information