create table tbtest
(
tid int null,
tname varchar(20) null
)
insert into tbtest values(1, 'aaa')
insert into tbtest values(2, 'aaa')
insert into tbtest values(2, 'aaa')
insert into tbtest values(2, 'aaa')
insert into tbtest values(3, 'bbb')
insert into tbtest values(3, 'bbb')
insert into tbtest values(4, 'ccc')
insert into tbtest values(4, 'ddd')
insert into tbtest values(5, 'eee')
select * from tbtest
go
with temp as
(
select tid,tname,row_number() OVER (PARTITION BY tid, tname ORDER BY tid) as rownumber from tbtest
)
select * from temp where rownumber=1
