Q：只distinct一个字段，查询多个字段。 A：借助count函数以及group by来实现

select *,count(distinct 字段名) from 表名 group by 字段名;
select *,count(distinct name) from table_test group by name;