close
筆記一下 BigQuery CASE WHEN ... THEN
的用法
SELECT name, CASE WHEN age = 1 THEN '18-25' WHEN age = 2 THEN '25-35' WHEN age = 3 THEN '35-45' WHEN age = 4 THEN '45-65' ELSE '不明' END AS age FROM user_date_table
超煩der
文章標籤
全站熱搜
留言列表