DISTINCT去重
课程：SQL · 编程练习
SQL编程练习 - DISTINCT去重
练习内容
-- 查询所有不重复的城市\nSELECT DISTINCT city FROM users;\n\n-- 查询不重复的状态\nSELECT DISTINCT status FROM orders;\n\n-- 统计不重复城市的数量\nSELECT COUNT(DISTINCT city) AS city_count\nFROM users;\n\n
课程：SQL · 编程练习
SQL编程练习 - DISTINCT去重
-- 查询所有不重复的城市\nSELECT DISTINCT city FROM users;\n\n-- 查询不重复的状态\nSELECT DISTINCT status FROM orders;\n\n-- 统计不重复城市的数量\nSELECT COUNT(DISTINCT city) AS city_count\nFROM users;\n\n