sql语句 过滤重复

select * ,count(DISTINCT name) from users group by name order by name ascselect *  from users group by name order by name ascselect id  from users group by name order by name asc

?

http://www.rongsen.com.cn/article/MySQL/2012/0320/9338.html? //资料来源

?

?