22,300
社区成员




UPDATE table1
SET table1.id_2 = t.id_2
FROM table1
LEFT JOIN (SELECT id_1 - 1 AS id_1,
id_2
FROM table1
WHERE id_1 > 2
) t
ON table1.id_1 = t.id_1
WHERE table1.id_1 >= 2