How many rows does each query return?
SELECT COUNT(*) FROM t WHERE 1 = 0; SELECT COUNT(*) FROM t WHERE 1 = 0 GROUP BY x;
- 0 and 0
- 1 and 1
- 0 and 1
- 1 and 0
An aggregate without
Play SQL & Databases ▸
GROUP BY always yields one row (count 0); with GROUP BY and no input there are no groups, so no rows.