题解 | 查询结果去重
查询结果去重
https://www.nowcoder.com/practice/82ebd89f12cf48efba0fecb392e193dd
# 方法一:关键字distinct select distinct university from user_profile; # 方法二:分组 group by 同样能达到去重效果 select university from user_profile group by university;
记住用group by也可以去重!!!
SQL练练练 文章被收录于专栏
记录自己sql的每一步提升!