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

image

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

Double Quoted Aliases are for Reserved Words and Spaces

image

“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. A good rule of thumb is to refer to the column by the alias ...

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

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