O'Reilly logo

Tera-Tom's 1000 page e-Book on Teradata by Tera-Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12

The WHERE Clause

“I have a dream that my four little children will one day live in a nation where they will not be judged by the color of their skin, but by the content of their character.

– Martin Luther King, Jr.

Table of Contents Chapter 12 – The WHERE Clause

The WHERE Clause limits Returning Rows

Using a Column ALIAS throughout the SQL

Double Quoted Aliases are for Reserved Words and Spaces

Character Data needs Single Quotes in the WHERE Clause

Character Data needs Single Quotes, but Numbers Don't

NULL means UNKNOWN DATA so Equal (=) won't Work

Use IS NULL or IS NOT NULL when dealing with NULLs

NULL is UNKNOWN DATA so NOT Equal won't Work

Use IS NULL or IS NOT NULL when dealing with NULLs

Using Greater Than ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required