Django group by

# If you mean to do aggregation you can use the aggregation features of the ORM:
from django.db.models import Count
Members.objects.values('designation').annotate(dcount=Count('designation'))

# This results in a query similar to:
SELECT designation, COUNT(designation) AS dcount
FROM members GROUP BY designation

#and the output would be of the form
[{'designation': 'Salesman', 'dcount': 2}, 
 {'designation': 'Manager', 'dcount': 2}]

Source: stackoverflow.com

Similar codes

1 vote169 views1 answer
Display data from database in django
Python Django
0 vote163 views1 answer
Django listview
Python Django
0 vote183 views1 answer
(django)inorder to provide a human readable name for the model.
Python Django
0 vote151 views1 answer
User passes test django
Python Django
10 votes175 views1 answer
Django new static files directory
Python Django
0 vote170 views1 answer
Django validate_comma_separated_integer_list
Python Django
15 votes184 views4 answers
Django python install
Python Django
-2 votes186 views1 answer
Start django project in windows
Python Django
4 votes159 views3 answers
Flash messages django
Python Django
0 vote209 views1 answer
Django import settings variables
Python Django