Null Values in SQL Queries

Re:Null Values in SQL Queries by mumblemumble on Monday February 03, 2020 @10:54AM (#22225240)

Letting null equal null might work okay for a WHERE clause, but it turn JOINing into a terrible muddle. And I don't want null to behave different ways in different clauses.

[ Parent | on HN ]

Re:Null Values in SQL Queries by SigmundA on Monday February 03, 2020 @12:37PM (#22226569)

Already behaves differently in GROUP BY, UNION, DISTINCT and PARTITION.

[ Parent | on HN ]