By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Jobs
(
RowNumber1 int,
GroupJobID int,
JobID varchar(10)
);
INSERT INTO Jobs(RowNumber1, GroupJobID, JobID)
VALUES(1, 6200, 'A001'),
(1, 6200, 'A002'),
(2, 6202, 'A003'),
(2, 6202, 'A004'),
(2, 6202, 'A005'),
(3, 6201, 'A006'),
(3, 6201, 'A007'),
(3, 6201, 'A008'),
(3, 6201, 'A009'),
(4, 6202, 'A010'),
(5, 6201, 'A011')
SELECT RowNumber1, GroupJobID, JobID, ROW_NUMBER() OVER(PARTITION BY RowNumber1, GroupJobID ORDER BY JobID) RowNumber2
FROM Jobs
| RowNumber1 | GroupJobID | JobID | RowNumber2 |
|---|---|---|---|
| 1 | 6200 | A001 | 1 |
| 1 | 6200 | A002 | 2 |
| 2 | 6202 | A003 | 1 |
| 2 | 6202 | A004 | 2 |
| 2 | 6202 | A005 | 3 |
| 3 | 6201 | A006 | 1 |
| 3 | 6201 | A007 | 2 |
| 3 | 6201 | A008 | 3 |
| 3 | 6201 | A009 | 4 |
| 4 | 6202 | A010 | 1 |
| 5 | 6201 | A011 | 1 |