Question

sql不用distinct怎么去重复？

Answer 1

不用第distinct就用group by
select distinct name from user
select name from user group by name
这两个结果是一样的

Answer 2

去除重复的行 distinct与unique功能用法相同 也可以使用group by

Answer 3

group by
表 user
列 username pwd
abc 1234
abc 13131
fsfsfsd 44234
select * from user group by username;

输出 : abc 1234
asfsfsd 44234

Answer 4

说这么复杂？建主索引不也ok嘛！还省时省力！