笔记

Mysql distinct count

Mysql, 笔记

Mysql distinct count

1
select userId,count(*) as cnt from user group by userId having cnt>1;