{"blog_title":"\u307e\u305a\u306f\u874b\u306e\u7ffc\u304b\u3089\u3002","provider_name":"Hatena Blog","type":"rich","description":"\u5f0a\u793e\u306eDMT\u7528SQL\u3067\u8b0e\u306a\u66f8\u304d\u65b9\u304c\u3042\u3063\u305f\u3002 \u8b0eSQL \u30c6\u30fc\u30d6\u30ebtbl1\u306e\u4e2d\u8eab\u306flog\u30c6\u30fc\u30d6\u30eb\u3067\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u611f\u3058\u3060\u3068\u3059\u308b(\u30e6\u30fc\u30b6\u30fc\u306f\u8907\u6570\u30bb\u30b0\u30e1\u30f3\u30c8\u306b\u5272\u308a\u632f\u3089\u308c\u3066\u3044\u308b)\u3002 user_id segment log_time log_date log_hh log_mm 100 10\u4ee3 2018-03-01 00:01:00 2018-03-01 00 01 100 10\u4ee3 2018-03-01 00:01:01 2018-03-01 00 01 100 \u7537\u6027 2018-03-01 00:01:00 2018-03-01 00 01 100 \u7537\u6027 2018-03-01 00:01:01 2018-03\u2026","published":"2018-03-21 04:23:02","author_name":"chito_ng","provider_url":"https://hatena.blog","image_url":null,"version":"1.0","blog_url":"https://knknkn.hatenablog.com/","title":"\u30d5\u30e9\u30b0\u3092\u7528\u3044\u305f\u30c6\u30af\u30cb\u30ab\u30eb\u306aCOUNT DISTINCT","categories":["SQL"],"url":"https://knknkn.hatenablog.com/entry/2018/03/21/042302","author_url":"https://blog.hatena.ne.jp/chito_ng/","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fknknkn.hatenablog.com%2Fentry%2F2018%2F03%2F21%2F042302\" title=\"\u30d5\u30e9\u30b0\u3092\u7528\u3044\u305f\u30c6\u30af\u30cb\u30ab\u30eb\u306aCOUNT DISTINCT - \u307e\u305a\u306f\u874b\u306e\u7ffc\u304b\u3089\u3002\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","width":"100%"}