django同一个表格分组后统计个数
tem = eq.values_list("stateDevice").order_by("stateDevice").distinct().annotate(count=Count("stateDevice"))
此处需要查询的数据在同一个表格中,如果不去重直接如下(去重之前要先排个序,不然去重失效) 得不到正确结果,
tem = eq.values_list("stateDevice").annotate(count=Count("stateDevice"))
//另一种写法会得到字典
tem = eq.values("stateDevice").order_by("stateDevice").distinct().annotate(count=Count("stateDevice"))
//
原文:https://www.cnblogs.com/RYSBlog/p/14631825.html