django orm在同一个表格中操作模拟groupby

 

 

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"))

 

//