count(distinct xxx) 和 group by 做去重隐藏的坑
不说废话,直接上代码。以下查询是基于mysql自带的country,city,countrylanguage三个样例表做的:select count(*) from countryunion all SELECT count(distinct Code, Name, Continent, Region, SurfaceArea, IndepYear, Population, Life...
原创
2019-07-11 10:50:43 ·
5488 阅读 ·
1 评论