如图:我需要统计 issue=3 的每个用户记录出现的次数,我不熟sql一些函数,求教应该用哪个?
应该得出:
峰 = 3
骄傲 = 1
青枫 = 3
小小= 1
select user, count(1)
from table_name
where issue = 3
group by user
直接分类count就可以
SELECT count(index), user FROM table WHERE issue=3 GROUP BY user;
select [user], count(*)
from YourTable
where issue='3'
group by [user]