1. 打开重复记录的单个字段：
select distinct name from table
2. 打开重复记录的所有字段值：
select * from table where fid in(select min(fid) from table group by name)
假定：name字段包含重复值
3. 打开重复任意次数的所有记录：
select * from table where name in(select name from table group by name having count(name)=1)