如何在bigquery中使用rowid按日期获取数据集的第一个值，并将给定日期的所有其他值设置为0

SELECT *
FROM `your_project.your_dataset.your_table`

SELECT *,
       ROW_NUMBER() OVER (PARTITION BY date_column ORDER BY date_column) AS row_num
FROM `your_project.your_dataset.your_table`

SELECT *
FROM (
  SELECT *,
         ROW_NUMBER() OVER (PARTITION BY date_column ORDER BY date_column) AS row_num
  FROM `your_project.your_dataset.your_table`
) t
WHERE row_num = 1

SELECT *,
       CASE WHEN date_column = '给定日期' THEN value_column ELSE 0 END AS new_value
FROM (
  SELECT *,
         ROW_NUMBER() OVER (PARTITION BY date_column ORDER BY date_column) AS row_num
  FROM `your_project.your_dataset.your_table`
) t
WHERE row_num = 1