O'Reilly logo

Tera-Tom Genius Series - Hadoop Architecture and SQL by Jason Nolander, 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 – Interrogating the Data

"The difference between genius and stupidity is that genius has its limits"

- Albert Einstein

Quiz – Fill in the Answers for the NULLIF Command

image

What would the above Answer Set produce from your analysis?

Quiz – Fill in the Answers for the NULLIF Command

image

Look at the answers above. Do they make sense? If not, go over it again until they do. The NULLIF command will compare two values in a list. If they are equal it will put a Null in the answer set, but if the two values are not equal, then it will choose the first ...

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