ayuLiao
12/8/2018 - 8:29 AM

mysql查询

mysql去重查询,将select查询出的相同过滤,统计不重复的数据数


# distinct 删除vAccount相同的值
# COUNT统计查询出的个数
select COUNT(distinct vAccount) from level_up where dtTime between 1544025600 and 1544111999;>