create table #a (订单编号 varchar(10), status bit , 采购员 varchar(10))
insert into #a (订单编号,status,采购员) values('1',1,'sa')
insert into #a (订单编号,status,采购员) values('2',1,'sa')
insert into #a (订单编号,status,采购员) values('3',1,'sa')
insert into #a (订单编号,status,采购员) values('4',1,'sa')
insert into #a (订单编号,status,采购员) values('5',1,'sa')
insert into #a (订单编号,status,采购员) values('6',1,'sa')
insert into #a (订单编号,status,采购员) values('11',1,'yy')
insert into #a (订单编号,status,采购员) values('12',1,'yy')
insert into #a (订单编号,status,采购员) values('13',1,'yy')
insert into #a (订单编号,status,采购员) values('14',1,'yy')
insert into #a (订单编号,status,采购员) values('15',1,'yy')
insert into #a (订单编号,status,采购员) values('16',1,'yy')
insert into #a (订单编号,status,采购员) values('21',1,'zz')
insert into #a (订单编号,status,采购员) values('22',1,'zz')
insert into #a (订单编号,status,采购员) values('23',1,'zz')
select 采购员
from #a
where status=1
group by 采购员
having count(*)>5