django 一个关于分组查询的问题分析

时间:2022-11-14 23:48:10
 ret=Emp.objects.values('dep').annotate(avg_salary=Avg('salary'))
print(ret)
# ---*******单表分组查询ORM总结:表名.objects.values('group by 的字段').annotate(聚合函数('统计的字段')
from django.db.models import Avg,Count,Min,Max

ret = models.Publish.objects.values('nid').annocate(c=Count('book__name'))
print(ret) # <querySet[{'nid':'ccc','c':'xxx'}]>
ret = models.Publish.objects.values('nid').annocate(c=Count('book__name')).values('name','c')
print(ret) # <querySet[{'name':'ccc','c':'xxx'}]>
ret = models.Publish.objects.values('nid').annocate(c=Count('book__name')).filter(name='人民出版社').values('name','c')
print(ret) # <querySet[{'name':'ccc','c':'xxx'}]>,这里面的filter相当于having,先group_by后having

其他可以参照类似上诉格式