SQL SERVER过滤重复查询

作者: 吴杰 分类: 编程 发布时间: 2015-03-24 17:19

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

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