{"id":6436,"date":"2023-01-19T04:56:54","date_gmt":"2023-01-19T04:56:54","guid":{"rendered":"https:\/\/www.pythontutorial.net\/?page_id=6436"},"modified":"2023-01-19T06:49:33","modified_gmt":"2023-01-19T06:49:33","slug":"django-group-by","status":"publish","type":"page","link":"https:\/\/www.pythontutorial.net\/django-tutorial\/django-group-by\/","title":{"rendered":"Django Group By"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn how to use Django Group By with aggregate functions to calculate aggregation for groups.<\/p>\n\n\n\n

Introduction to the Django Group By #<\/a><\/h2>\n\n\n\n

The SQL GROUP BY<\/code><\/a> clause groups the rows returned by a query into groups. Typically, you use aggregate functions<\/a> like count, min, max, avg, and sum with the GROUP BY<\/code> clause to return an aggregated value for each group.<\/p>\n\n\n\n

Here’s the basic usage of the GROUP<\/code> BY<\/code> clause in a SELECT<\/code> statement:<\/p>\n\n\n

SELECT<\/span> column_1, AGGREGATE<\/span>(column_2)\nFROM<\/span> table_name\nGROUP<\/span> BY<\/span> column1;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In Django, you can you the annotate()<\/code> method with the values()<\/code> to apply the aggregation on groups like this:<\/p>\n\n\n
(Entity.objects\n    .values('column_2'<\/span>)\n    .annotate(value=AGGREGATE('column_1'<\/span>))\n)<\/code><\/span>Code language:<\/span> Python<\/span> (<\/span>python<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax;<\/p>\n\n\n\n