sql distinct去除重复

distinct

select  distinct * from  table1

或者用

group  by