Databases · Junior · Question 66 of 75

What is the result of SELECT 10 + NULL?

Explanation

Almost any operation with NULL gives NULL, because the result is unknown. Use COALESCE(value, 0) when NULL should count as zero.

Further reading

Problem with a question

Databases · Junior · question 66

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.

Take this quiz