Update Target
Last updated
Was this helpful?
Last updated
Was this helpful?
Was this helpful?
UPDATE TABLE1
SET Column1 = 1;UPDATE ONLY(TABLE2)
SET Column1 = 1;UPDATE (SELECT EMPNO, SALARY, COMM,
AVG(SALARY) OVER (PARTITION BY WORKDEPT),
AVG(COMM) OVER (PARTITION BY WORKDEPT)
FROM EMPLOYEE E) AS E(EMPNO, SALARY, COMM, AVGSAL, AVGCOMM)
SET (SALARY, COMM) = (AVGSAL, AVGCOMM)
WHERE EMPNO = '000120';UPDATE TABLE1
SET Column1 = 1;UPDATE/*** MSC-WARNING - MSCEWI5004 - ONLY TABLE REFERENCE IS NOT APPLICABLE IN SNOWFLAKE. ***/ TABLE2
SET Column1 = 1;UPDATE
-- ** MSC-ERROR - MSCEWI5006 - INTERMEDIATE RESULT TABLE IS NOT SUPPORTED. **
-- (SELECT EMPNO, SALARY, COMM,
-- AVG(SALARY) OVER (PARTITION BY WORKDEPT),
-- AVG(COMM) OVER (PARTITION BY WORKDEPT)
-- FROM EMPLOYEE E)
AS E
-- ** MSC-ERROR - MSCEWI5006 - INTERMEDIATE RESULT TABLE IS NOT SUPPORTED. **
-- (EMPNO, SALARY, COMM, AVGSAL, AVGCOMM)
SET
SALARY = AVGSAL,
COMM = AVGCOMM
WHERE EMPNO = '000120';