SQL SERVER过滤重复查询

SQL SERVER过滤重复查询,在Browser表中过滤重复的IP:

select * from Browser a where not exists (select 1 from Browser where Ip = a .Ip and id < a.id )