select max(id) as id,name from member group by name
比这个强select distinct name from member
不使用DISTINCT消除重复数据
未经允许不得转载：小叶白龙博客 » 不使用DISTINCT消除重复数据
select max(id) as id,name from member group by name
比这个强select distinct name from member
