SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE ORGTable (
id INTEGER,
type VARCHAR(30) NOT NULL,
info VARCHAR(30) NOT NULL
)
INSERT INTO ORGTable (id, type, info)
VALUES
('1','type1','info1'),
('1','type2','info2'),
('1','type3','info3'),
('2','type4','info4'),
('2','type5','info5'),
('3','type6','info6'),
('3','type7','info7'),
('4','type8','info8'),
('5','type9','info9')
9 rows affected

SELECT TOP 1 * FROM ORGTable WHERE id = 1


id
type
info


1
type1
info1


UPDATE  TOP (1) ORGTable SET type = 'type99',info = 'info99' WHERE id = '1'
1 rows affected

SELECT * FROM ORGTable  WHERE id = 1


id
type
info


1
type99
info99

1
type2
info2

1
type3
info3


;WITH cte AS
(
   SELECT *,
         ROW_NUMBER() OVER (PARTITION BY id ORDER BY id) AS rn
   FROM ORGTable WHERE type='type99'
)
UPDATE cte SET type = 'type88',info = 'info99' WHERE rn = 1
1 rows affected

SELECT * FROM ORGTable


id
type
info


1
type88
info99

1
type2
info2

1
type3
info3

2
type4
info4

2
type5
info5

3
type6
info6

3
type7
info7

4
type8
info8

5
type9
info9

id	type	info
1	type88	info99
1	type2	info2
1	type3	info3
2	type4	info4
2	type5	info5
3	type6	info6
3	type7	info7
4	type8	info8
5	type9	info9