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