shigemk2 https://blog.hatena.ne.jp/shigemk2/ by shigemk2 https://www.shigemk2.com/ 6.3. Conditional Expressions — 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書いてないときにelseに相当するデータが来たら、表示されないのかと思いきやnullが返ってくるので、表示させたくないなら別途whereで弾くしかない。 0.221 190 <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> Hatena Blog https://hatena.blog 2019-06-17 23:42:18 rich https://www.shigemk2.com/entry/2019/06/17/234218 1.0 100%