hideney https://blog.hatena.ne.jp/hideney/ Big Bro Hide’s Blog https://hide-blo.hateblo.jp/ Snowflake Snowflakeにて以下のSQLを実行。 WITH target_date AS ( SELECT TO_DATE('20230128', 'YYYYMMDD') AS pnr_date ), date_ranges AS ( SELECT pnr_date, DATEADD('DAY', 1 - DAYOFWEEK(pnr_date), pnr_date) AS previous_saturday FROM target_date ), weeks AS ( SELECT previous_saturday, DATEADD('WEEK', SEQ4(), previous_saturda… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhide-blo.hateblo.jp%2Fentry%2F2024%2F08%2F08%2F101751" title="【Snowflake】1～52週までの繰り返しレコードの取得 - Big Bro Hide’s Blog" 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 2024-08-08 10:17:51 rich https://hide-blo.hateblo.jp/entry/2024/08/08/101751 1.0 100%