1UPDATE table
2SET column1 = expression1,
3 column2 = expression2,
4 ...
5 column_n = expression_n
6[WHERE conditions];
1UPDATE mytable t -- Update using WITH statement
2SET value3 = (
3 WITH comp AS (
4 SELECT id, value1
5 FROM mytable t
6 WHERE value2 > 10
7 )
8 SELECT c.value1
9 FROM comp c
10 WHERE c.id = t.id
11);