Learning SQL Confirmed Errata

Errata

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question

Version	Location	Description	Submitted By	Corrected
Printed	Page xi Section: "Conventions Used in This Book"	italics removed from the term "UPPERCASE" ##############################################	Anonymous	Apr 2007
Printed	Page 12 Section: "What's in Store"; 1st sentence	special emphasis of the" -> special emphasis on the" ##############################################	Anonymous	Apr 2007
Printed	Page 21 Table 2-5, range for HH (hours)	01 to 24 -> 00 to 23 ##############################################	Anonymous	Apr 2007
Printed	Page 21 Table 2-5, range for MI (minutes)	01 to 60 -> 00 to 59 ##############################################	Anonymous	Apr 2007
Printed	Page 47 1st paragraph	e.dept_id = d.dept_id -> employee.dept_id = department.dept_id ##############################################	Anonymous	Apr 2007
Printed	Page 50 3rd paragraph	If you want to your result set in a particular... -> If you want your result set in a particular... ##############################################	Anonymous	Apr 2007
Printed	Page 58 the sentence	...I am looking for nonterminated employees who are either nontellers or who began working for the bank in 2003 or later. -> ...I am looking for nonterminated employees who are both nontellers and began working for the bank in 2003 or later. ##############################################	Anonymous	Apr 2007
Printed	Page 59 WHERE clause at top of page	changed to: WHERE end_date IS NULL AND title != 'Teller' AND start_date >= '2003-01-01' ##############################################	Anonymous	Apr 2007
Printed	Page 77 2nd paragraph	value of 1 in it's dept_id column... -> value of 1 in its dept_id column... ##############################################	Anonymous	Apr 2007
Printed	Page 83 the sentence	The first subquery, which starts on line 3 and is given the alias e, finds all inexperienced tellers -> The first subquery, which starts on line 3 and is given the alias e, finds all experienced tellers ##############################################	Anonymous	Apr 2007
Printed	Page 83 2nd paragraph	First, the account table is joined to the inexperienced teller subquery... -> First, the account table is joined to the experienced teller subquery... ##############################################	Anonymous	Apr 2007
Printed	Page 113 2nd paragraph, 2nd sentence	The fourth comparison also 0yields, -> The fourth comparison also yields 0, ##############################################	Anonymous	Apr 2007
Printed	Page 116 Last paragraph, 1st sentence	...replaced with the string 'hello' Oracle Database... -> ...replaced with the string 'hello'. Oracle Database... ##############################################	Anonymous	Apr 2007
Printed	Page 137 Last row, under Min()	Return -> Returns ##############################################	Anonymous	Apr 2007
Printed	Page 142 2nd paragraph	Throughout the paragraph, "data.num" was used as an argument for the aggregate functions. This was changed to "val" instead. ##############################################	Anonymous	Apr 2007
Printed	Page 142 Section beginning with "Generating Groups" at bottom of page	The last paragraph (including section title) on page 142 is duplicated at the top of the next page, 143.	Anonymous	Sep 2007
Printed	Page 151 2nd SELECT statement on the page	FROM account a -> FROM account ##############################################	Anonymous	Apr 2007
Printed	Page 186 Paragraph continued from page 185	Therefore, when using outer joins (both inner and outer), make sure you think carefully about whether to specify a left or right outer join. -> Therefore, when using outer joins, make sure you think carefully about whether to specify a left or right outer join. ##############################################	Anonymous	Apr 2007
Printed	Page 193 MySQL example, line 1	SELECT a.account_id, a.cust_id, b.name -> SELECT a.account_id, a.cust_id, a.open_branch_id, b.name ##############################################	Anonymous	Apr 2007
Printed	Page 219 1st row	of rows larger then -> of rows larger than ##############################################	Anonymous	Apr 2007
Printed	Page 220 SHOW INDEX statement	Key_name: dept_name_uidx -> Key_name: dept_name_idx ##############################################	Anonymous	Apr 2007
Printed	Page 230 2nd paragraph	While neither SQL Server or Oracle Database generate an... -> While neither SQL Server nor Oracle Database generates an... ##############################################	Anonymous	Apr 2007
Printed	Page 244 4th paragraph, 1st sentence	Earlier in the chapter, I showed you how write queries... -> Earlier in the chapter, I showed you how to write queries... ##############################################	Anonymous	Apr 2007
Printed	Page 256 app C, example 6-3, 2nd query;	SELECT fname, name -> SELECT fname, lname ##############################################	Anonymous	Apr 2007
Printed	Page 262 5th line of solution for Exercise 9-4	WHERE b. branch_id = e.assigned_branch_id) branch_name -> WHERE b.branch_id = e.assigned_branch_id) branch_name ##############################################	Anonymous	Apr 2007