{"id":491,"date":"2024-08-30T01:30:13","date_gmt":"2024-08-30T01:30:13","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=491"},"modified":"2025-06-01T13:52:27","modified_gmt":"2025-06-01T13:52:27","slug":"having","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/having\/","title":{"rendered":"HAVING"},"content":{"rendered":"\n

SQL HAVING Keyword<\/h2>\n\n\n\n

The HAVING clause is used to filter groups of records after they have been grouped using GROUP BY. It is typically used with aggregate functions like COUNT, SUM, AVG, MAX, or MIN. Unlike WHERE, which filters rows before grouping, HAVING filters after grouping.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL HAVING Syntax<\/h2>\n\n\n\n
SELECT column_name, AGGREGATE_FUNCTION(column_name)\nFROM table_name\nGROUP BY column_name\nHAVING AGGREGATE_FUNCTION(column_name) condition;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL HAVING with GROUP BY Example<\/h2>\n\n\n\n
The following SQL lists how many patients exist for each gender in the Patients table, and only includes genders that have more than 2 patients:<\/p>\n\n\n\n
SELECT gender, COUNT(patient_id)\nFROM Patients\nGROUP BY gender\nHAVING COUNT(patient_id) > 2;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL HAVING with ORDER BY<\/h2>\n\n\n\n
The next example also sorts the results in descending order of patient count:<\/p>\n\n\n\n
SELECT gender, COUNT(patient_id)\nFROM Patients\nGROUP BY gender\nHAVING COUNT(patient_id) > 2\nORDER BY COUNT(patient_id) DESC;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL HAVING Labs<\/h2>\n\n\n\n