{"id":400,"date":"2021-03-25T15:14:50","date_gmt":"2021-03-25T06:14:50","guid":{"rendered":"https:\/\/gri.jp\/media\/entry\/400"},"modified":"2022-07-19T16:22:46","modified_gmt":"2022-07-19T07:22:46","slug":"tableau-bysql1","status":"publish","type":"post","link":"https:\/\/gri.jp\/media\/entry\/400","title":{"rendered":"SQL\u306e\u982d\u3067\u7406\u89e3\u3059\u308bTableau"},"content":{"rendered":"<p>\u79c1\u304c\u6700\u521dTableau\u3092\u3055\u308f\u3063\u305f\u3068\u304d\u306b\u601d\u3063\u305f\u3053\u3068\u306f\u3001\u3053\u306e\u51fa\u6765\u4e0a\u304c\u3063\u305f\u30c1\u30e3\u30fc\u30c8\u306f\u3001\u8981\u306f\u5143\u306e\u30c7\u30fc\u30bf\u3092\u3069\u3046\u96c6\u8a08\u3057\u305f\u4e0a\u3067\u53ef\u8996\u5316\u3057\u3066\u308b\u3093\u3060\uff1f\u3067\u3057\u305f\u3002LOD\u3092\u4f7f\u3044\u59cb\u3081\u308b\u3068\u7279\u306b\u3002\u305d\u3057\u3066\u3001\u30c1\u30e3\u30fc\u30c8\u3092\u3064\u304f\u308b\u306b\u3042\u305f\u3063\u3066\u6700\u7d42\u7684\u306b\u3069\u3046\u96c6\u8a08\u3057\u305f\u306e\u304b\u3092\u3001\u5168\u90e8SQL\u3067\u6559\u3048\u3066\u304f\u308c\u306a\u3044\u304b\u306a\u3068\u601d\u3044\u307e\u3057\u305f\u3002\u5c11\u3057\u8abf\u3079\u305f\u9650\u308a\u3067\u306f\u3001\u305d\u306e\u3088\u3046\u306b\u89e3\u8aac\u3057\u3066\u3044\u308b\u8a18\u4e8b\u306a\u3069\u306f\u3042\u307e\u308a\u898b\u3064\u304b\u3089\u306a\u304b\u3063\u305f\u3068\u601d\u3044\u307e\u3059\u3002\u305d\u308c\u3092\u66f8\u3044\u3066\u307f\u3088\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u307e\u305a\u3001\u57fa\u672c\u7684\u306b\u306f\u3001\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306fGROUP BY\u3067\u3001\u30e1\u30b8\u30e3\u30fc\u306fSUM\u306a\u3069\u3067\u96c6\u8a08\u3055\u308c\u307e\u3059\u3002\u591a\u304f\u306e\u5834\u5408\u3001\u9752\u306fGROUP BY\u3067\u3059\u3002\u2193<\/p>\n<img decoding=\"async\" class=\"hatena-fotolife\" title=\"\" src=\"\/media\/wp\/wp-content\/uploads\/2021\/08\/20210325144753.png\" alt=\"f:id:gri-blog:20210325144753p:plain\" \/>\n<p><!--more--><\/p>\n<p>\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306e\u30d5\u30a3\u30eb\u30bf\u3092\u4f7f\u3063\u305f\u3068\u3059\u308c\u3070\u3001SQL\u7684\u306b\u306fWHERE\u306b\u306a\u308a\u307e\u3059\uff08\u30d5\u30a3\u30eb\u30bf\u306b\u3082\u8272\u3005\u3042\u308a\u307e\u3059\u304c\u3001\u3044\u3063\u305f\u3093\u306fWHERE\u3068\u3057\u307e\u3059\uff09\u3002\u2193<\/p>\n<img decoding=\"async\" class=\"hatena-fotolife\" title=\"\" src=\"\/media\/wp\/wp-content\/uploads\/2021\/08\/20210325144855.png\" alt=\"f:id:gri-blog:20210325144855p:plain\" \/>\n<p>\u30e1\u30b8\u30e3\u30fc\u306e\u30d5\u30a3\u30eb\u30bf\u3092\u9069\u7528\u3057\u305f\u3068\u3059\u308b\u3068\u3001HAVING\u3067\u3059\u3002\u2193<\/p>\n<img decoding=\"async\" class=\"hatena-fotolife\" title=\"\" src=\"\/media\/wp\/wp-content\/uploads\/2021\/08\/20210325145107.png\" alt=\"f:id:gri-blog:20210325145107p:plain\" \/>\n<p>\u30e1\u30b8\u30e3\u30fc\u3092\uff12\u3064\u306b\u3057\u3066\u3082\u3001SQL\u306f\u307b\u307c\u540c\u3058\u3067\u3059\u3002\u2193<\/p>\n<img decoding=\"async\" class=\"hatena-fotolife\" title=\"\" src=\"\/media\/wp\/wp-content\/uploads\/2021\/08\/20210325145231.png\" alt=\"f:id:gri-blog:20210325145231p:plain\" \/>\n<p>\u30c1\u30e3\u30fc\u30c8\u306e\u7a2e\u985e\u3092\u5909\u3048\u3066\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u3092\u30c6\u30ad\u30b9\u30c8\u3084\u8a73\u7d30\u306b\u5165\u308c\u3066\u3082\u3001\u4f7f\u308f\u308c\u3066\u3044\u308b\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u3068\u30e1\u30b8\u30e3\u30fc\u304c\u540c\u3058\u3067\u3042\u308c\u3070\u3001SQL\u306f\u540c\u3058\u3067\u3059\u3002\u2193<\/p>\n<img decoding=\"async\" class=\"hatena-fotolife\" title=\"\" src=\"\/media\/wp\/wp-content\/uploads\/2021\/08\/20210325145356.png\" alt=\"f:id:gri-blog:20210325145356p:plain\" \/>\n<img decoding=\"async\" class=\"hatena-fotolife\" title=\"\" src=\"\/media\/wp\/wp-content\/uploads\/2021\/08\/20210325145546.png\" alt=\"f:id:gri-blog:20210325145546p:plain\" \/>\n<p>\u3067\u306f\u3001\u5c11\u3057\u3060\u3051LOD\u3092\u8003\u3048\u3066\u307f\u307e\u3057\u3087\u3046\u3002LOD\u81ea\u4f53\u3092\u7df4\u7fd2\u3059\u308b\u306b\u306f\u3001\u3053\u3061\u3089\u306e\u30b5\u30a4\u30c8\u3092\u898b\u306a\u304c\u3089\u4e00\u901a\u308a\u3084\u3063\u3066\u307f\u308b\u306e\u304c\u3044\u3044\u3067\u3059\u3002<\/p>\n<p><iframe class=\"embed-card embed-webcard\" style=\"display: block; width: 100%; height: 155px; max-width: 500px; margin: 10px 0px;\" title=\"LOD \u8868\u73fe\u30c8\u30c3\u30d7 15\" src=\"https:\/\/hatenablog-parts.com\/embed?url=https%3A%2F%2Fwww.tableau.com%2Fja-jp%2Fabout%2Fblog%2FLOD-expressions\" frameborder=\"0\" scrolling=\"no\"><\/iframe><cite class=\"hatena-citation\"><a href=\"https:\/\/www.tableau.com\/ja-jp\/about\/blog\/LOD-expressions\">www.tableau.com<\/a><\/cite><\/p>\n<p>\u3053\u3053\u3067\u306f\u3001Tableau\u306e\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u4e0a\u8a18\u30b5\u30a4\u30c8\u306e\u300c\uff11. \u9867\u5ba2\u306e\u30aa\u30fc\u30c0\u30fc\u983b\u5ea6\u300d\u3092\u8003\u3048\u3066\u307f\u307e\u3059\u3002\u64cd\u4f5c\u306e\u30a4\u30e1\u30fc\u30b8\u306f\u3053\u306e\u3088\u3046\u306b\u306a\u308b\u3068\u601d\u3044\u307e\u3059\u3002\u2193<\/p>\n<img decoding=\"async\" class=\"hatena-fotolife\" title=\"\" src=\"\/media\/wp\/wp-content\/uploads\/2021\/08\/20210325150019.png\" alt=\"f:id:gri-blog:20210325150019p:plain\" \/>\n<p>\u3067\u3001\u672c\u984c\u3067\u3059\u304c\u3001\u3053\u3053\u3067\u4f5c\u6210\u3057\u305f<\/p>\n<pre class=\"code\" data-lang=\"\" data-unlink=\"\">{ FIXED [\u9867\u5ba2 ID]: COUNTD([\u30aa\u30fc\u30c0\u30fc ID]) }<\/pre>\n<p>\u306f\u3001\u3064\u307e\u308a\u30c7\u30fc\u30bf\u3092\u3069\u3046\u52a0\u5de5\u3057\u3066\u3044\u308b\u306e\u304b\u3001\u3067\u3059\u3002LOD\u306f\u3044\u3063\u305f\u3093[\u9867\u5ba2 ID]\u3092\u4f7f\u3063\u3066GROUP BY\u3057\u305f\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3092\u3001\u5143\u306b\u30c7\u30fc\u30bf\u306b[\u9867\u5ba2 ID]\u3067\u7d50\u5408\u3057\u3066\u3044\u308b\u3068\u8003\u3048\u3066\u3082\u3044\u3044\u306e\u3067\u3001\u4f8b\u3048\u3070SQL\u306f\u3053\u3046\u3067\u3057\u3087\u3046\u304b\u3002\u2193<\/p>\n<img decoding=\"async\" class=\"hatena-fotolife\" title=\"\" src=\"\/media\/wp\/wp-content\/uploads\/2021\/08\/20210325150657.png\" alt=\"f:id:gri-blog:20210325150657p:plain\" \/>\n<p>\u6ce8\u6587\u56de\u65706\u56de\u306e\u4eba\u304c\u3001141\u4eba\u3068\u3044\u3046\u96c6\u8a08\u7d50\u679c\u306f\u3001\u5143\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u30c7\u30fc\u30bf\u304b\u3089\u76f4\u63a5\u306f\u51fa\u305b\u306a\u3044\u306e\u3067\u3001LOD\u3092\u4f7f\u3063\u3066\u4e00\u65e6GROUP BY\u3057\u305f\u3082\u306e\u3092\u7528\u610f\u3057\u3066\u304a\u304d\u3001\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306b\u6301\u3063\u3066\u304d\u3066\u6700\u7d42\u7684\u306bCOUNT(DISTINCT [\u9867\u5ba2 ID])\u3092\u3057\u3066\u3044\u308b\u306e\u3067\u3059\u306d\u3002<\/p>\n<p>\u5c11\u3057\u30a4\u30e1\u30fc\u30b8\u304c\u3067\u304d\u307e\u3057\u305f\u3067\u3057\u3087\u3046\u304b\u3002<br \/>\n\u4e0a\u8a18\u5185\u5bb9\u304c\u3001\u79c1\u304cTableau\u521d\u65e5\u306b\u6559\u3048\u3066\u307b\u3057\u304b\u3063\u305f\u306a\u3068\u601d\u3063\u305f\u5185\u5bb9\u3067\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u79c1\u304c\u6700\u521dTableau\u3092\u3055\u308f\u3063\u305f\u3068\u304d\u306b\u601d\u3063\u305f\u3053\u3068\u306f\u3001\u3053\u306e\u51fa\u6765\u4e0a\u304c\u3063\u305f\u30c1\u30e3\u30fc\u30c8\u306f\u3001\u8981\u306f\u5143\u306e\u30c7\u30fc\u30bf\u3092\u3069\u3046\u96c6\u8a08\u3057\u305f\u4e0a\u3067\u53ef\u8996\u5316\u3057\u3066\u308b\u3093\u3060\uff1f\u3067\u3057\u305f\u3002LOD\u3092\u4f7f\u3044\u59cb\u3081\u308b\u3068\u7279\u306b\u3002\u305d\u3057\u3066\u3001\u30c1\u30e3\u30fc\u30c8\u3092\u3064\u304f\u308b\u306b\u3042\u305f\u3063\u3066\u6700\u7d42\u7684\u306b\u3069\u3046\u96c6\u8a08\u3057\u305f\u306e<\/p>\n","protected":false},"author":22,"featured_media":2179,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,124],"tags":[],"class_list":["post-400","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-datascience","category-tableau"],"acf":[],"meta_field":{"_edit_last":["38"],"_wp_page_template":["default"],"memo":["\u306a\u3057"],"_edit_lock":["1658215264:38"],"_pv_count":["a:24:{i:7;i:29;i:23;i:23;i:4;i:89;i:14;i:39;i:1;i:60;i:16;i:32;i:19;i:22;i:18;i:28;i:20;i:36;i:11;i:46;i:2;i:92;i:8;i:32;i:12;i:28;i:22;i:20;i:3;i:111;i:21;i:23;i:13;i:33;i:6;i:42;i:15;i:28;i:5;i:65;i:17;i:27;i:10;i:35;i:9;i:33;i:0;i:19;}"],"pv_count":["992"],"_thumbnail_id":["2179"],"hidden_toppage":["0"],"_hidden_toppage":["field_61933136630d2"],"note_url":[""],"_note_url":["field_61243c8278b90"]},"_links":{"self":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts\/400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/comments?post=400"}],"version-history":[{"count":6,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts\/400\/revisions"}],"predecessor-version":[{"id":8508,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts\/400\/revisions\/8508"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/media\/2179"}],"wp:attachment":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/media?parent=400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/categories?post=400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/tags?post=400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}