SQL Server 2019

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

CREATE TABLE t
    (ID int, Name varchar(12), col_3 varchar(3), col_4 varchar(3))
;
    
INSERT INTO t
    (ID, Name, col_3, col_4)
VALUES
    (1, 'name_1', 'x_1', 'y_1'),
    (2, 'name_2', 'x_2', 'y_2'),
    (3, 'name_3', 'x_3', 'y_3'),
    (4, 'name_4', 'x_4', 'y_4'),
    (1, 'other_name_1', 'x_5', 'y_5'),
    (2, 'other_name_2', 'x_6', 'y_6'),
    (5, 'name_5', 'x_7', 'y_7')
;
7 rows affected

select *
from   t


ID
Name
col_3
col_4


1
name_1
x_1
y_1

2
name_2
x_2
y_2

3
name_3
x_3
y_3

4
name_4
x_4
y_4

1
other_name_1
x_5
y_5

2
other_name_2
x_6
y_6

5
name_5
x_7
y_7


select id
      ,min(name) over(partition by id) as name
      ,col_3
      ,col_4
from   t


id
name
col_3
col_4


1
name_1
x_1
y_1

1
name_1
x_5
y_5

2
name_2
x_6
y_6

2
name_2
x_2
y_2

3
name_3
x_3
y_3

4
name_4
x_4
y_4

5
name_5
x_7
y_7

ID	Name	col_3	col_4
1	name_1	x_1	y_1
2	name_2	x_2	y_2
3	name_3	x_3	y_3
4	name_4	x_4	y_4
1	other_name_1	x_5	y_5
2	other_name_2	x_6	y_6
5	name_5	x_7	y_7