shigemk2 https://blog.hatena.ne.jp/shigemk2/ by shigemk2 https://www.shigemk2.com/ Presto presto with withよくわかんなかったけど、サブクエリの簡素化だね、やっていることは。 WITH dataset AS ( SELECT * FROM ( VALUES (1, 'A'), (2, 'B'), (3, 'C'), (4, 'D'), (5, 'A'), (6, 'B'), (7, 'C'), (9, 'A'), (10, 'B'),(11, 'C'), (13, 'A'),(14, 'B'),(15, 'C'), (17, 'A'),(18, 'B'),(19, 'C'), (21, 'A'),(22, 'B'),(23, 'C'), (25, 'A'),(26, … 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.shigemk2.com%2Fentry%2F2018%2F02%2F05%2Fpresto_with" title="presto with - 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 2018-02-05 21:43:09 rich https://www.shigemk2.com/entry/2018/02/05/presto_with 1.0 100%