{"id":489,"date":"2024-08-30T01:30:04","date_gmt":"2024-08-30T01:30:04","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=489"},"modified":"2025-06-01T13:40:11","modified_gmt":"2025-06-01T13:40:11","slug":"group-by","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/group-by\/","title":{"rendered":"GROUP BY"},"content":{"rendered":"\n

SQL GROUP BY Keyword<\/h2>\n\n\n\n

The GROUP BY keyword is used to group rows that share the same value in specified columns. It’s commonly paired with aggregate functions like COUNT(), SUM(), AVG(), MIN(), and MAX() to summarize data.<\/p>\n\n\n\n

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

SQL GROUP BY Syntax<\/h2>\n\n\n\n
SELECT column_name, aggregate_function(column_name)\nFROM table_name\nGROUP BY column_name;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL GROUP BY Patients Gender Example <\/h2>\n\n\n\n
This query lists how many patients are grouped by gender:<\/p>\n\n\n\n
SELECT gender, COUNT(patient_id)\nFROM Patients\nGROUP BY gender;<\/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 GROUP BY Doctors Specialty Example <\/h2>\n\n\n\n
This query counts how many doctors belong to each specialty in the Doctors table and lists them from highest to lowest count:<\/p>\n\n\n\n
SELECT specialty, COUNT(doctor_id)\nFROM Doctors\nGROUP BY specialty\nORDER BY COUNT(doctor_id) DESC;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL GROUP BY Labs<\/h2>\n\n\n\n