{"id":583,"date":"2023-01-31T20:49:14","date_gmt":"2023-01-31T12:49:14","guid":{"rendered":"https:\/\/scutvk.cn\/?p=583"},"modified":"2023-01-31T21:01:55","modified_gmt":"2023-01-31T13:01:55","slug":"%e6%a3%80%e6%9f%a5group%e4%b8%ad%e7%9a%84%e6%98%af%e5%90%a6%e5%ad%98%e5%9c%a8%e5%80%bc%e7%ad%89%e4%ba%8e-bigquery-sql-%e4%b8%ad%e7%9a%84%e7%89%b9%e5%ae%9a%e5%80%bc","status":"publish","type":"post","link":"https:\/\/scutvk.cn\/?p=583","title":{"rendered":"\u68c0\u67e5group\u4e2d\u7684\u662f\u5426\u5b58\u5728\u503c\u7b49\u4e8e BigQuery SQL \u4e2d\u7684\u7279\u5b9a\u503c"},"content":{"rendered":"\n<p>\u6211\u6709\u4e00\u4e2a\u5982\u4e0b\u6240\u793a\u7684\u6570\u636e\u96c6\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">ID|Date_Val|Data\r\n1|2022-01-01|A\r\n1|2022-01-01|I\r\n1|2022-01-01|H\r\n2|2022-01-01|G\r\n2|2022-01-01|G\r\n2|2022-01-01|I<\/code><\/pre>\n\n\n\n<p>\u6211\u60f3\u8fd0\u884c\u5982\u4e0b\u6240\u793a\u7684\u67e5\u8be2\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">SELECT ID, Date_Val, IF(SELECT ID, Date_Val,\r\n       CASE WHEN MAX(CASE WHEN Data = 'A' THEN 1 END) > 0 THEN 'A' ELSE 'B' END AS Data\r FROM yourTable\r GROUP BY 1, 2;\n, 'A', 'B')\nGROUP BY 1,2<\/code><\/pre>\n\n\n\n<p>\u8f93\u51fa\u6570\u636e\u96c6\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">ID|Date_Val|Data\r\n1|2022-01-01|A\r\n2|2022-01-01|B<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6211\u6709\u4e00\u4e2a\u5982\u4e0b\u6240\u793a\u7684\u6570\u636e\u96c6\uff1a \u6211\u60f3\u8fd0\u884c\u5982\u4e0b\u6240\u793a\u7684\u67e5\u8be2&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[2],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/scutvk.cn\/index.php?rest_route=\/wp\/v2\/posts\/583"}],"collection":[{"href":"https:\/\/scutvk.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scutvk.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scutvk.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/scutvk.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=583"}],"version-history":[{"count":1,"href":"https:\/\/scutvk.cn\/index.php?rest_route=\/wp\/v2\/posts\/583\/revisions"}],"predecessor-version":[{"id":584,"href":"https:\/\/scutvk.cn\/index.php?rest_route=\/wp\/v2\/posts\/583\/revisions\/584"}],"wp:attachment":[{"href":"https:\/\/scutvk.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scutvk.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scutvk.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}