Python-如何在Django中以GROUP BY查询？

Python-如何在Django中以GROUP BY查询？

如果你打算进行聚合，则可以使用ORM的聚合功能：

from django.db.models import CountMembers.objects.values('designation').annotate(dcount=Count('designation'))

这导致查询类似于

SELECt designation, COUNT(designation) AS dcountFROM members GROUP BY designation

并且输出将为以下形式

[{'designation': 'Salesman', 'dcount': 2},  {'designation': 'Manager', 'dcount': 2}]