create table #t1 ( c1 int,c2 int,c3 int);
insert into #t1 values(1,0,1);
insert into #t1 values(2,0,2);
insert into #t1 values(3,1,1);
insert into #t1 values(4,0,3);
insert into #t1 values(5,1,2);
insert into #t1 values(6,0,4);
insert into #t1 values(7,1,3);
insert into #t1 values(8,1,4);
insert into #t1 values(9,0,5);
go
select c1,c2,row_number() OVER
(PARTITION BY c2 ORDER BY c1)
from #t1
EXCEPT
select c1,c2,c3
from #t1