查询第一次重复的记录

如
id name
1   a 
2   b  
3   a  
4   a  
5   b  
6   c  

结果

id name
4    a 
5    b 
6    c 

create table tb(ID int,         Name varchar(10))
insert into tb values(1 ,             'a') 
insert into tb values(2 ,             'b') 
insert into tb values(3 ,             'c') 
insert into tb values(4 ,             'a') 
insert into tb values(5 ,             'b') 
insert into tb values(6 ,             'c') 
insert into tb values(7 ,             'a') 
insert into tb values(8 ,             'b') 
insert into tb values(9 ,             'c')
go

select id , name from
(
select * , px = (select count(1) from tb where name = t.name and id < t.id) + 1 from tb t
) m
where px = 2

select id , name from
(
select * , px = row_number() over(partition by name order by id) from tb t
) m
where px = 2