使用 DISTINCT 对查询出来的语句去重
SELECT DISTINCT provinceCode From city 查询单个字段,对单个字段去重
SELECT DISTINCT provinceCode,provinceName From city 查询多个字段,对多个字段去重
使用 DISTINCT 对查询出来的语句去重
SELECT DISTINCT provinceCode From city 查询单个字段,对单个字段去重
SELECT DISTINCT provinceCode,provinceName From city 查询多个字段,对多个字段去重