Chapter 2 – The WHERE Clause

“I saw the angel in the marble and carved until I set him free.”

- Michelangelo

The WHERE Clause limits Returning Rows


The WHERE Clause above filters how many ROWS are coming back. In this example, I am asking for the report of only rows WHERE the first name is Henry.

Double Quoted Aliases are for Reserved Words and Spaces


“Write a wise saying and your name will live forever.”

- Anonymous

When you ALIAS a column, you give it a new name for the report header, but a good rule of thumb is to refer to the column by the ...

Get Tera-Tom Genius Series - DB2 SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.