一、使用distinct
distinct cloumn1, cloumn2
这样的mysql 会认为要过滤掉name和id两个字段都重复的记录;
如果sql这样写:select cloumn1, distinct cloumn2 from tablename
,这样mysql会报错,因为distinct必须放在要查询字段的开头
select distinct cloumn1, cloumn2 from tablename;
二、使用group by
select id,name from user group by name;