Errata

SQL Hacks

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page 127
3rd paragraph

The text currently reads:

"Cleese earns $30,100 and pays 10 percent on the $20,000 from $10,000 to $30,000 but then has to pay 15 percent of that $100 over the $30,000 limit. His bill will be $200 + $15 = $215."

The calculation is wrong it will be: _$2,000_ + $15 = _$2015_.

Interestingly, the SQL on the following page (128) comes up with the correct results. It's just the text which is wrong.

Anonymous  Apr 09, 2015 
Printed Page 299
3rd paragraph

Descendants is incorrectly spelled as "descendents".

Same mistake on following page, 300 - last line of text (before the sample SQL).

Anonymous  May 06, 2015