Null (SQL): Difference between revisions

Revision as of 23:19, 10 October 2021

Revision as of 12:58, 5 November 2021

Line 33:

</syntaxhighlight>

This can lead to unanticipated results. For instance, when an attempt is made to divide Null by zero, platforms may return Null instead of throwing an expected "data exception{{snd}} division by zero".<ref name="SQL2003-Part2-Sec626"/> Though this behavior is not defined by the ISO SQL standard many DBMS vendors treat this operation similarly. For instance, the Oracle, PostgreSQL, MySQL Server, and Microsoft SQL Server platforms all return a Null result for the following:

<syntaxhighlight lang="sql">