# 方法一：关键字distinct
select distinct university from user_profile;
# 方法二：分组 group by 同样能达到去重效果
select university from user_profile group by university;

记住用group by也可以去重！！！