Errata

 

Corrections to “The Language of SQL, 2nd Edition”

Chapter 3 – section “Table Aliases” – pages 24 and 25:
The first two SQL statements in this section are:

SELECT,
LastName
FROM Sales123 AS Sales

SELECT,
Sales.LastName
FROM Sales123 AS Sales

For both statements, there should not be a comma after the keyword SELECT.

Chapter 4 – section “What is a Function?” – page 27:
In the second paragraph of this section, a sentence reads:
“However, regardless of the type or number of input values, functions always return precisely one output value when the function is invoked.”
It should be:
“However, regardless of the type or number of input values, functions almost always return precisely one output value when the function is invoked.”

Chapter 4 – section “Date/Time Functions” – page 34:
The sentence “The day is 2 (Monday).” should read: “The day is 6.”

Chapter 4 – section “Date/Time Functions” – page 34:
The first column header on the table on this page reads: “DATEPART Function Expression”. It should be: “DATEDIFF Function Expression”.

Chapter 5 – section “Sorting in Ascending Order” – page 42:
The first SELECT with an ORDER BY LastName shows Natalie Lopez appearing before Connie King. Connie King should appear before Natalie Lopez.

Chapter 5 – section “Sorting by a Calculated Field” – page 44:
The sentence that begins with “We inserted a column and a space” should read: “We inserted a comma and a space”.

Chapter 9 – section “The COUNT Function” – page 85:
The second table on the page should have the title column “Count of Homework Scores” rather than “Count of Homework Rows”.

Chapter 10 – section “Adding Subtotals with CUBE” – page 108:
The sentence in the second paragraph that ends with “view subtotals by State or by Column” should read: “view subtotals by State or by Channel”.

Chapter 12 – section “Full Joins” – page 131:
The table on the top of the page is missing one row. The following row should appear right after the row “Restricted / Everyone Says I Love You”:
Restricted / Love Actually

Chapter 13 – section “Referencing Views” – page 140:
In the first row of data in the data output box, the last name appears as “Shajh”. It should be “Shah”.

Chapter 15 – section “Distinct and Non-Distinct Unions” – pages 158-159:
In two SQL statements, the line:
ReturnDate as ‘Date’
should read:
ReturnDate AS ‘Date’

Chapter 15 – section “Intersecting Queries” – pages 159-161:
In two SQL statements, the lines:
ReturnDate as ‘Date’
should read:
ReturnDate AS ‘Date’

Chapter 15 – section “Looking Ahead” – page 161:
In the first paragraph, there are two sentences that contain the word “INTERCEPT”. This word should be “INTERSECT”.

Corrections to “Data Analysis with Microsoft Access 2010”

Chapter 7 – section “Math and Financial Functions” – page 139:
The sentences “The INT function converts the specified number to an integer, simply by dropping any decimal places. It doesn’t do any rounding.” should read: “The INT function converts the specified number to an integer, by rounding down to the next lower integer.”

Chapter 10 – section “Using Subqueries as Fields” – page 218:
In the first sentence of the paragraph that begins “Our next example,” the phrase “subqueries as a data source” should read “subqueries as a field.”

Corrections to “The Language of SQL, 1st Edition”

Chapter 11 – section “Table Aliases Revisited” – page 116:
In the Database Differences sidebar, all the single quotes should be double quotes.

Chapter 13 – section “Self Joins” – page 132:
The sentence “To accomplish this, we’re going to create a self join of the Employees table to itself.” should read: “To accomplish this, we’re going to create a self join of the Personnel table to itself.”

Chapter 14 – section “Using a Subquery as a Data Source” – page 144:
In the statement after the sentence “In general form, the main SELECT statement in the above is”, the line that reads:
INNER JOIN
should read:
LEFT JOIN

Chapter 14 – section “Using a Subquery as a Data Source” – page 144:
In the data that appears after the sentence “If the subquery were executed by itself, the results would be”, the data for SumOfOrders for CustomerID 1 should be 22.25.

Chapter 17 – section “Inserting Data” – page 176:
The phrase “after the INSERT TO” should read “after the INSERT INTO”.

Additional Corrections to the Kindle Version of “The Language of SQL, 1st Edition”

Chapter 5 – section “Sorting by Multiple Columns”
The words “Sorting by a Calculated Field 51″ erroneously appear in the middle of the last sentence in the section. The sentence should read: Your intention is to sort first by LastName and then by FirstName, so you need to list the LastName column first.”

Advertisements
Comments Off on Errata
%d bloggers like this: