{"provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/misos/","version":"1.0","url":"https://paper.hatenadiary.jp/entry/2017/05/01/000000","author_name":"misos","height":"190","blog_url":"https://paper.hatenadiary.jp/","type":"rich","image_url":null,"description":"\u4f7f\u3044\u305d\u3046\u306b\u306a\u3063\u305f\u306e\u3067. ModelName\u304c\u30e2\u30c7\u30eb\u306e\u540d\u524d, attribute_name\u304cgroup by\u3092\u884c\u3044\u305f\u3044\u30ab\u30e9\u30e0\u306e\u540d\u524d\u3067\u3059. from django.db.models import Count target_data = ModelName.objects.all() groupby_data = target_data.values('attribute_name').annotate(total=Count('attribute_name')).order_by('total') \u30ab\u30a6\u30f3\u30c8\u3092\u884c\u3063\u305f\u3042\u3068\u306e total \u5c5e\u6027\u306b\u30ec\u30b3\u30fc\u30c9\u6570\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059. \u8a73\u3057\u304f\u306f\u4ee5\u4e0b\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u2026","title":"Python django\u3067Group by\u3092\u7528\u3044\u3066\u8981\u7d20\u3054\u3068\u306e\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3057\u3066\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306b\u6e21\u3059","provider_name":"Hatena Blog","categories":["python","SQL"],"width":"100%","published":"2017-05-01 00:00:00","blog_title":"\u3081\u3082","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fpaper.hatenadiary.jp%2Fentry%2F2017%2F05%2F01%2F000000\" title=\"Python django\u3067Group by\u3092\u7528\u3044\u3066\u8981\u7d20\u3054\u3068\u306e\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3057\u3066\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306b\u6e21\u3059 - \u3081\u3082\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}