Lesson 19 of 3259%
(Progress persistence is disabled until Phase 9)
SQL
Beginner
HAVING Clause
Filter grouped records.
HAVING Clause
Filter grouped records.
Example
-- Find countries with more than 1 user
SELECT country, COUNT(*) as count FROM users GROUP BY country HAVING count > 1;Test it Yourself