1. 打開重復記錄的單個字段：
select distinct name from table
2. 打開重復記錄的所有字段值：
select * from table where fid in(select min(fid) from table group by name)
假定：name字段包含重復值
3. 打開重復任意次數(shù)的所有記錄：
select * from table where name in(select name from table group by name having count(name)=1)