SQL SERVER过滤重复查询,在Browser
表中过滤重复的IP:
select * from Browser a where not exists (select 1 from Browser where Ip = a .Ip and id < a.id )
SQL SERVER过滤重复查询,在Browser
表中过滤重复的IP:
select * from Browser a where not exists (select 1 from Browser where Ip = a .Ip and id < a.id )