如何在Django中查詢組？我質(zhì)疑一個模型：Members.objects.all()它還會：Eric, Salesman, X-ShopFreddie, Manager, X2-ShopTeddy, Salesman, X2-ShopSean, Manager, X2-Shop我想知道最好的Django方法group_by查詢我的數(shù)據(jù)庫，例如：Members.objects.all().group_by('designation')當然不管用。我知道我們可以在django/db/models/query.py，但我只是好奇，知道如何做到這一點，而不需要修補。
3 回答
米脂
TA貢獻1836條經(jīng)驗 獲得超3個贊
from django.db.models import CountMembers.objects.values('designation').annotate(dcount=Count('designation'))SELECT designation, COUNT(designation) AS dcount FROM members GROUP BY designation
[{'designation': 'Salesman', 'dcount': 2},
{'designation': 'Manager', 'dcount': 2}]添加回答
舉報
0/150
提交
取消