使用select-in和多个输出列更新表

ogq8wdun 于 2021-07-26 发布在 Java

关注(0)|答案(1)|浏览(300)

查询错误：输入的子查询只能有一个输出列。如何更新此表？谢谢您

UPDATE table
       SET ViewItem = SessionStart
       WHERE  (event_date, user_pseudo_id) 
       IN 
       (SELECT event_date, user_pseudo_id
        FROM table
        WHERE ViewItem > SessionStart
        GROUP BY event_date, user_pseudo_id
        ORDER BY event_date, user_pseudo_id
       )
;

sql google-bigquery

来源：https://stackoverflow.com/questions/62441204/update-table-using-select-in-with-multiple-output-column

1条答案

按热度按时间

rnmwe5a21#

试试下面

UPDATE table
       SET ViewItem = SessionStart
       WHERE  (event_date, user_pseudo_id) 
       IN 
       (SELECT AS STRUCT event_date, user_pseudo_id
        FROM table
        WHERE ViewItem > SessionStart
        GROUP BY event_date, user_pseudo_id
        ORDER BY event_date, user_pseudo_id
       )
;

赞(0）回复(0）举报 2021-07-26

我来回答

使用select-in和多个输出列更新表

1条答案

相关问题

热门标签

最新问答