YouTip

# SQLite Having Clause The HAVING clause allows you to specify conditions to filter the grouped results that appear in the final result set. The WHERE clause sets conditions on selected columns, while the HAVING clause sets conditions on the groups created by the GROUP BY clause. ## Syntax Here is the position of the HAVING clause in a SELECT query: SELECT FROM WHERE GROUP BY HAVING ORDER BY In a query, the HAVING clause must be placed after the GROUP BY clause and before the ORDER BY clause. Here is the syntax for a SELECT statement containing a HAVING clause: SELECT column1, column2 FROM table1, table2 WHERE GROUP BY column1, column2 HAVING ORDER BY column1, column2 ## Examples Assume the COMPANY table has the following records: ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ----------1 Paul 32 California 20000.02 Allen 25 Texas 15000.03 Teddy 23 Norway 20000.04 Mark 25 Rich-Mond 65000.05 David 27 Texas 85000.06 Kim 22 South-Hall 45000.07 James 24 Houston 10000.08 Paul 24 Houston 20000.09 James 44 Norway 5000.010 James 45 Texas 5000.0 Here is an example that will display all records where the name count is less than 2: sqlite > SELECT * FROM COMPANY GROUP BY name HAVING count(name) SELECT * FROM COMPANY GROUP BY name HAVING count(name) > 2; This will produce the following result: ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ----------10 James 45 Texas 5000