SQL Knowledge Center · About ·
Easy Interactive Online SQL Training for Beginners

SQL NULL Tutorial - Interactive Database Lesson

Lesson 19 of 31

Lessons

1. SELECT *
2. SELECT specific columns
3. WHERE ... Equals
4. WHERE ... Greater than
5. WHERE ... Greater than or equal
6. AND
7. OR
8. IN
9. DISTINCT
10. ORDER BY
11. LIMIT # of returned rows
12. COUNT(*)
13. COUNT(*) ... WHERE
14. SUM
15. AVG
16. MAX and MIN
17. GROUP BY
18. Nested queries
19. NULL
20. Date
21. Inner joins
22. Multiple joins
23. Joins with WHERE
24. Left joins
25. Table alias
26. Column alias
27. Self joins
28. LIKE
29. CASE
30. SUBSTR
31. COALESCE

NULL

Interactive SQL Tutorial

Sometimes, in a given row, there is no value at all for a given column. For example, a dog does not have a favorite book, so in that case there is no point in putting a value in the favorite_book column, and the value is NULL. In order to find the rows where the value for a column is or is not NULL, you would use IS NULL or IS NOT NULL.

Can you return all of the rows of family_members where favorite_book is not null?

SQL:

Query Result:

Available Tables:

Languages: English, Español, Portoghese, Italiano, Français, 日本語, Deutsch, اللغة العربية

2017 - 2023 · SQL-Easy.com. A Beekeeper Studio Project.

About · Cookie Policy