create table testTB
(no int
, nm varchar(10)
, addr varchar(100)
)
go

insert into testTB
 select 1 ,    '홍길동',   '홍길동집1' union all
 select 2 ,    '홍길동',   '홍길동집2' union all
 select 3 ,    '홍길동',   '홍길동집3' union all
 select 4 ,    '전지현',   '전지현집1' union all
 select 5 ,    '전지현',   '전지현집2' union all
 select 6 ,    '전지현',   '전지현집3' union all
 select 7 ,    '전지현',   '전지현집4'

go

select
 a.no
 , [nm] = isnull(b.nm, '')
 , a.addr
from
 testTB a
 left outer join (select nm, no = min(no) from testTB group by nm)  b
 on a.no = b.no
 and a.nm = b.nm
 
 go