Re:Null Values in SQL Queries
by oarabbus_ on Tuesday February 04, 2020 @01:18AM
(#22232916)
Often in analytics you will create datasets which are an amalgamation of several upstream sources. For example, an Endangered Species database. You might have "wing length" and "number of eyes" as fields, and both of these need to be NULL for something like a sea urchin.
There's really no justification to avoid nulls as a principle.
There's really no justification to avoid nulls as a principle.