Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Oppiskele SQL Null | Filtering Statements
SQL Tutorial for Beginners

book
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 NULL

  • IS NOT NULL: detects values that are not NULL.

SELECT title FROM songs
WHERE album IS NOT NULL
12
SELECT title FROM songs WHERE album IS NOT NULL
copy

NULL does not match 0 or empty line, it only matches data that is missing and does not exist.

NULL values are ignored in the MIN, MAX, COUNT, AVG, and SUM aggregate functions.

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 3. Luku 1
single

single


Query ResultQuery Result
No query executed yet...

Kysy tekoälyä

expand

Kysy tekoälyä

ChatGPT

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

some-alt