假设表名是 Comp 出现重复的列是 name 主键编号是Id(可以是Guid类型,也可以是int类型)
一:下面是去除重复的sql语句:
select * from Comp cp right join (select name,Max(Id) as tempID from Comp group by name)
AS temp on cp.Id = temp.tempID order by cp.name
重复的数据每次查询时只会显示一条。
二:下面是排除掉重复的数据(即有重复数据的就全部排除掉不显示):
select * from Comp cp inner join (select name,count(1) AS num from Comp group by name)
AS temp on cp.name = temp.name where temp.num = 1
同理当temp.num>1时,可以取出所有的重复项。