1:使用distinct select distinct name from a where statesign=0 查询表a中的name字段,去除重复记录 2:使用group by select name from a where statesign=0 group by name 查询表a中的name字段,分组,去除重复记录
mysql查询去除重复记录1:使用distinctselect distinct name from a where statesign=0查询表a中的name字段,去除重复记录2:使用group byselect name from a where statesign=0 group by name查询表a中的name字段,分组,去除重复记录...