选择不重复记录的单个字段
select distinct name from table1
打开不重复记录的所有字段值
select * from table1 where id in(select min(id) fromtable group by field1)
打开不重复任意次数的所有记录
select * from table1 where name in (select name from table group by name having count(name)=1)