{"width":"100%","author_name":"takuya_1st","author_url":"https://blog.hatena.ne.jp/takuya_1st/","description":"sql \u3067 \u3044\u3061\u3044\u3061 group by count \u3084\u308b\u306e\u9762\u5012 \u30c6\u30fc\u30d6\u30eb\u4f5c\u3063\u3066\u30fc create table words ( word text ) ; \u30c7\u30fc\u30bf\u6295\u5165\u3057\u3066\u30fc insert into words values ( \"aaaa\" ) ; .. \u96c6\u8a08\u3057\u3066 select word, count(*) as from words group by word order by cnt desc ; \u3048\uff1f\u3001\u3001\u8868\u8a08\u7b97\uff1f\u305d\u308c\u306f\u3061\u3087\u3063\u3068\u8003\u3048\u305f\u304f\u306a\u3044 \u30b3\u30de\u30f3\u30c9\u3067\u697d\u52dd \u30c6\u30ad\u30b9\u30c8\u4e2d\u306e\u91cd\u8907\u6587\u5b57\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b\u306b uniq -c \u3092\u4f7f\u3048\u308b\u3002 cat - | sort | uniq -c | sort -r -n\u2026","url":"https://takuya-1st.hatenablog.jp/entry/2015/01/08/205812","blog_url":"https://takuya-1st.hatenablog.jp/","published":"2015-01-08 20:58:12","type":"rich","version":"1.0","categories":[],"title":"\u30d5\u30a1\u30a4\u30eb\u306e\u3001\u6587\u5b57\u5217\u306e\u767b\u5834\u56de\u6570\u30e9\u30f3\u30ad\u30f3\u30b0\u3092\u4f5c\u308b","image_url":null,"blog_title":"\u305d\u308c\u30de\u30b0\u3067\uff01","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftakuya-1st.hatenablog.jp%2Fentry%2F2015%2F01%2F08%2F205812\" title=\"\u30d5\u30a1\u30a4\u30eb\u306e\u3001\u6587\u5b57\u5217\u306e\u767b\u5834\u56de\u6570\u30e9\u30f3\u30ad\u30f3\u30b0\u3092\u4f5c\u308b - \u305d\u308c\u30de\u30b0\u3067\uff01\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190"}