Valeurs NULL :

SQL intermédiaire

Jasmin Ludolf

Data Science Content Developer, DataCamp

Valeurs manquantes

COUNT(field_name) ne compte que les valeurs non manquantes
COUNT(*) inclut les valeurs manquantes

null

Valeurs manquantes :
- Erreur humaine
- Information non disponible
- Inconnue

null

SELECT COUNT(*) AS count_records
FROM people;

|count_records|
|-------------|
|8397         |

SELECT *
FROM people;

|id|name              |birthdate |deathdate|
|--|------------------|----------|---------|
|1 |50 Cent           |1975-07-06|null     |
|2 |A. Michael Baldwin|1963-04-04|null     |
|3 |A. Raven Cruz     |null      |null     |
...

IS NULL

SELECT name
FROM people
WHERE birthdate IS NULL;

|name         |
|-------------|
|A. Raven Cruz|
|A.J. DeLucia |
|Aaron Hann   |
...

IS NOT NULL

SELECT COUNT(*) AS no_birthdates
FROM people
WHERE birthdate IS NULL;

|no_birthdates|
|-------------|
|2245         |

SELECT COUNT(name) AS count_birthdates
FROM people
WHERE birthdate IS NOT NULL;

|count_birthdates|
|----------------|
|6152            |

COUNT vs. IS

SELECT 
   COUNT(certification) 
   AS count_certification
FROM films;

|count_certification|
|-------------------|
|4666               |

SELECT 
   COUNT(certification) 
   AS count_certification
FROM films
WHERE certification IS NOT NULL;

|count_certification|
|-------------------|
|4666               |

NULL en termes simples

Les valeurs NULL sont des valeurs manquantes
Très fréquentes
Utilisez IS NULL ou IS NOT NULL pour :
- Identifier les valeurs manquantes
- Sélectionner les valeurs manquantes
- Exclure les valeurs manquantes

Passons à la pratique !

SQL intermédiaire