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.
Obrigado pelo seu feedback!
single
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
Resumir este capítulo
Explicar o código em file
Explicar por que file não resolve a tarefa
Awesome!
Completion rate improved to 4.17
SQL Null
Deslize para mostrar o menu
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.
Obrigado pelo seu feedback!
Awesome!
Completion rate improved to 4.17single