{"blog_title":"\u4e16\u754c\u4e2d\u306e\u7f8a\u3092\u304b\u304d\u96c6\u3081\u3066","width":"100%","type":"rich","provider_url":"https://hatena.blog","categories":["Ruby"],"title":"\u30b7\u30a7\u30eb\u4e0a\u304b\u3089SQL\u3092\u5b9f\u884c\u3057\u3066\u7c21\u5358\u306b\u96c6\u8a08\u3067\u304d\u308b\u30e9\u30a4\u30d6\u30e9\u30ea\u300csssummary\u300d\u3092\u4f5c\u3063\u305f","provider_name":"Hatena Blog","height":"190","url":"https://shepherdmaster.hateblo.jp/entry/20130716/1373995961","author_name":"shepherdMaster","description":"\u30b7\u30a7\u30eb\u4e0a\u304b\u3089SQL\u3092\u5b9f\u884c\u3057\u3066\u7c21\u5358\u306b\u96c6\u8a08\u3067\u304d\u308b\u300csssummary\u300d\u3068\u3044\u3046\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u4f5c\u3063\u305f\u3002 rubygems -> https://rubygems.org/gems/sssummary github -> https://github.com/akira-kuriyama/sssummary\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u3068\u304bCSV\u3068\u304bTSV\u3068\u304b\u3001\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3055\u308c\u305f\u30d5\u30a1\u30a4\u30eb\u306b\u5bfe\u3057\u3066\u30b7\u30a7\u30eb\u4e0a\u304b\u3089\u96c6\u8a08\u3057\u305f\u3044\u3053\u3068\u3042\u308b\u3088\u306d\uff1f \u305d\u306e\u5834\u5408\u3001\u3060\u3044\u305f\u3044grep\u3068\u304bwc -l, uniq -c, sort, awk \u3068\u304b\u3067\u9811\u5f35\u308b\u3093\u3060\u3051\u3069\u3082\u3063\u3068\u30ab\u30b8\u30e5\u30a2\u30eb\u306b\u96c6\u8a08\u3057\u305f\u3044\u3068\u601d\u3046\u3088\u306d\uff1f\u305d\u3046\u3001SQL\uff01 SQL\u3067\u96c6\u8a08\u3057\u305f\u3044\uff01\uff01\u4f8b\u3048\u3070\u4ee5\u4e0b\u306e\u3088\u2026","version":"1.0","published":"2013-07-16 02:32:41","author_url":"https://blog.hatena.ne.jp/shepherdMaster/","image_url":null,"blog_url":"https://shepherdmaster.hateblo.jp/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshepherdmaster.hateblo.jp%2Fentry%2F20130716%2F1373995961\" title=\"\u30b7\u30a7\u30eb\u4e0a\u304b\u3089SQL\u3092\u5b9f\u884c\u3057\u3066\u7c21\u5358\u306b\u96c6\u8a08\u3067\u304d\u308b\u30e9\u30a4\u30d6\u30e9\u30ea\u300csssummary\u300d\u3092\u4f5c\u3063\u305f - \u4e16\u754c\u4e2d\u306e\u7f8a\u3092\u304b\u304d\u96c6\u3081\u3066\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}