SQL3、查询结果去重
思路:去除重复项需要用到关键字DISTINCT
代码解释:从表user_profile
中取出 去除了重复项的列university
SELECT
DISTINCT university
FROM
user_profile;
思路:去除重复项需要用到关键字DISTINCT
代码解释:从表user_profile
中取出 去除了重复项的列university
SELECT
DISTINCT university
FROM
user_profile;