关键字:DISTINCT
1.不加DISTINCT
select city_code, city_name from <表名>;
结果:
2.加 DISTINCT
select DISTINCT city_code, city_name from <表名>;
结果:
关键字:DISTINCT
1.不加DISTINCT
select city_code, city_name from <表名>;
结果:
2.加 DISTINCT
select DISTINCT city_code, city_name from <表名>;
结果: