sql update with statement

1--update query example
2 UPDATE table_name
3 SET column1 = value1, column2 = value2, ...
4 WHERE condition; 

1UPDATE table_name
2SET column1 = value1, column2 = value2...., columnN = valueN
3WHERE [condition];
4

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);