O'Reilly logo

Tera-Tom Genius Series - Kognitio Architecture and SQL by Leona Coffing, 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 5 – The WHERE Clause

“When I was 14 I thought my parents were the stupidest people in the world. When I was 21 I was amazed at how much they learned in seven years.”

- Mark Twain

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 ...

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