sql distinct去除重复

distinct

select  distinct * from  table1

或者用 

group  by