Null (SQL): Difference between revisions

Revision as of 12:42, 26 September 2023

Revision as of 00:08, 30 September 2023

Line 593:

</syntaxhighlight>

This query will always output exactly one row, counting of the number of employees whose last name contains "Jones", and giving the minimum and maximum wage found for those employees. However, what happens if none of the employees fit the given criteria? Calculating the minimum or maximum value of an empty set is impossible, so those results must be NULL, indicating there is no answer. This is not an Unknown value, it is a Null representing the absence of a value. The result would be:

{| class="wikitable" style="font-family:monospace"