{"categories":[],"blog_title":"by shigemk2","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.shigemk2.com%2Fentry%2F2019%2F06%2F17%2F234218\" title=\"presto case when - by shigemk2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","published":"2019-06-17 23:42:18","title":"presto case when","type":"rich","width":"100%","image_url":null,"provider_name":"Hatena Blog","blog_url":"https://www.shigemk2.com/","description":"6.3. Conditional Expressions \u2014 Presto 0.221 Documentation The result for the matching value is returned. If no match is found, the result from the ELSE clause is returned if it exists, otherwise null is returned. else\u66f8\u3044\u3066\u306a\u3044\u3068\u304d\u306belse\u306b\u76f8\u5f53\u3059\u308b\u30c7\u30fc\u30bf\u304c\u6765\u305f\u3089\u3001\u8868\u793a\u3055\u308c\u306a\u3044\u306e\u304b\u3068\u601d\u3044\u304d\u3084null\u304c\u8fd4\u3063\u3066\u304f\u308b\u306e\u3067\u3001\u8868\u793a\u3055\u305b\u305f\u304f\u306a\u3044\u306a\u3089\u5225\u9014where\u3067\u5f3e\u304f\u3057\u304b\u306a\u3044\u3002 0.221","height":"190","author_url":"https://blog.hatena.ne.jp/shigemk2/","url":"https://www.shigemk2.com/entry/2019/06/17/234218","author_name":"shigemk2"}