可以用GROUP BY如：select t.a from xxxx t GROUP BY t.a或者select distinct(t.a) from xxxx t 都可以去除重复
distinct关键字select distinct(列名) from 表名
select Name from user1 group by Name用group by分类汇总
