By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab
([ID] int, [CODE] varchar(1))
;
INSERT INTO tab
([ID], [CODE])
VALUES
(1, 'A'),
(1, 'B'),
(1, 'C'),
(1, 'D'),
(2, 'A'),
(2, 'B'),
(2, 'C')
;
7 rows affected