UPDATE mytable t -- Update using WITH statement SET value3 = ( WITH comp AS ( SELECT id, value1 FROM mytable t WHERE value2 > 10 ) SELECT c.value1 FROM comp c WHERE c.id = t.id );