Computer scienceFundamentalsSQL and DatabasesBasics SQLIntroduction to SQL

The NULL value

Mystery of NULL in SQL Arithmetic

Report a typo

In SQL, consider the following arithmetic expressions with NULL values. What will be the result of each operation? Choose the correct options.

SELECT 5 + NULL;

and

SELECT NULL / NULL;

Select one option from the list

The result of both expressions is NULL.

The result of the first expression is NULL and the result of the second expression is 1.

The result of the first expression is 5 and the result of the second expression is NULL.

The result of both expressions is 0.

___

Create a free account to access the full topic