SQL Null
NULL is a special value that matches missed data. It means there is no data inserted into the field.
There are operators to detect whether the value is NULL:
IS NULL
: detects only values that equal to NULLIS NOT NULL
: detects values that are not NULL.
12SELECT title FROM songs WHERE album IS NOT NULL
NULL
does not match 0 or empty line, it only matches data that is missing and does not exist.
NULL
values are ignored in theMIN
,MAX
,COUNT
,AVG
, andSUM
aggregate functions.
Bedankt voor je feedback!
single
Vraag AI
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.
Vat dit hoofdstuk samen
Explain code
Explain why doesn't solve task
Awesome!
Completion rate improved to 4.17
SQL Null
Veeg om het menu te tonen
NULL is a special value that matches missed data. It means there is no data inserted into the field.
There are operators to detect whether the value is NULL:
IS NULL
: detects only values that equal to NULLIS NOT NULL
: detects values that are not NULL.
12SELECT title FROM songs WHERE album IS NOT NULL
NULL
does not match 0 or empty line, it only matches data that is missing and does not exist.
NULL
values are ignored in theMIN
,MAX
,COUNT
,AVG
, andSUM
aggregate functions.
Bedankt voor je feedback!
Awesome!
Completion rate improved to 4.17single