Hi @Jim Seidel , please find the working example below:
CREATE TABLE TEST(
ID INTEGER,
KWID INTEGER ,
NAME VARCHAR (50) NOT NULL,
ORDERS INTEGER
);
INSERT INTO TEST
(ID, KWID, NAME)
VALUES
( 1447,1144 , 'SW_6368_58_51.png'),
( 1450,1145 , 'SW_6368_58_52.png'),
( 1451,1147 , 'SW_6368_58_53.png'),
( 1452,1147 , 'SW_6368_58_54.png'),
( 1453,1147 , 'SW_6368_58_55.png'),
( 1598,1152 , 'SW_6368_58_56.png');
UPDATE TEST t
SET orders = order2
FROM (
SELECT id, ROW_NUMBER() OVER (PARTITION BY kwid ORDER BY id) AS order2
FROM test
) s
WHERE t.id = s.id;
SELECT * FROM TEST;
Please try and let me know if this works for you or you still face any issues.
----------
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.