{"id":130448,"date":"2022-04-13T17:59:59","date_gmt":"2022-04-13T21:59:59","guid":{"rendered":"https:\/\/brainstation.io\/?post_type=codex-reference&p=130448"},"modified":"2025-02-04T14:40:45","modified_gmt":"2025-02-04T19:40:45","slug":"having","status":"publish","type":"codex-reference","link":"https:\/\/brainstation.io\/learn\/sql\/having","title":{"rendered":"Having"},"content":{"rendered":"\n
<\/path><\/path><\/path><\/g><\/path><\/path><\/path><\/g><\/svg>

SQL tutorial<\/p><\/div>

SQL Having<\/h1>

Learn more about SQL, a standard language for interacting with databases and storing, manipulating, and retrieving data from databases.

Go hands-on with SQL in our free interactive SQL tutorial.<\/a><\/p><\/div>

<\/div><\/div><\/div><\/header>\n\n\n\n
\n
\n

We have seen previously that we can filter data using the WHERE<\/code> clause and aggregate data using the GROUP BY<\/code> clause. <\/p>\n\n\n\n

While the former can be combined in a SELECT<\/code> statement with the latter, in order to filter data before <\/em>it is aggregated, one might initially think that it could also be used to do so afterward. <\/p>\n\n\n\n

For example,  if we wanted to find an employee last name that occurs in the employees table exactly 150 times,  we would assume that the query below would be valid:<\/p>\n\n\n\n

Code Example<\/span>