--省份相同
select * from vCount A
where not exists (select 1 from vCount where cArea=A.cArea and id>A.id)
--IP相同
select * from vCount A
where not exists (select 1 from vCount where cIp=A.cIp and id>A.id)
select * from vCount A
where not exists (select 1 from vCount where cArea=A.cArea and id>A.id)
--IP相同
select * from vCount A
where not exists (select 1 from vCount where cIp=A.cIp and id>A.id)
group by cip,carea