SQLite Having

SQLite HAVING is a SQLite clause that is used to specify conditions for SQLite grouping. SQLite HAVING syntax requires the use of SQLite aggregate functions. SQLite HAVING example uses include filtering SQLite GROUP BY results. SQLite HAVING can be used in conjunction with SQLite select.

Syntax

SELECT column1, column2, COUNT(*)
FROM table_name 
GROUP BY column1, column2
HAVING condition;

Example

In the SQLite HAVING example below, the city column is filtered to display only values greater than 1.

SELECT city, COUNT(*)
FROM customers 
GROUP BY city
HAVING COUNT(city) > 1;

SQLite Having and Group By

The SQLite GROUP BY clause is used to group SQLite data by one or more columns. SQLite HAVING clause is used in conjunction with the SQLite GROUP BY clause to filter groups based on a specified condition.
For example, the following SQLite statement would group customers by city and then only return cities that start with San:

SELECT city, COUNT(*)
FROM customers 
GROUP BY city
HAVING city LIKE 'San%';