Handling NULL Equality in a WHERE Clause: Quick Tip
Sarah Lemaire, Manager, Vertica Documentation
June 25, 2018
Jim Knicely authored this post. The predicate SQL element (i.e., the WHERE clause) is a truth-test. If the predicate test is true, it returns a value. Each predicate is evaluated per row, so that when the predicate is part of an entire table SELECT statement, the statement can return multiple results. Sometimes you might want...