查询错误：IN类型的子查询必须只有一个输出列。如何更新此表？谢谢
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
)
;
尝试下面
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
)
;
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句