Как проверить количество null записей через SQL запрос?

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

# Кол-во null записей
SELECT count(*) as cnt
  FROM table_name
WHERE column_name IS NULL;

# Кол-во не null записей
SELECT count(*) as cnt
  FROM table_name
WHERE column_name IS NOT NULL;

# Кол-во null и не null записей
SELECT count(*) as cnt_null
  FROM table_name
WHERE column_name IS NULL
UNION ALL
SELECT count(*) as cnt_not_null
  FROM table_name
WHERE column_name IS NOT NULL;

1

SELECT COUNT(*) FROM table_name WHERE column_name IS NULL;