mysql查找重复项

Question

这是表格

fid  uid  time
12   34   1
1    34   2
15   34   5
1    33   10
12   33   10
1    33   12
13   33   15
16   34   123
22   32   453
1    32   456
1    33   457
1    32   460

现在我想计算每个 uid 的数量，其中 time is >9 和 fid=1像这样

uid     number of duplications
33      3
32      2

Answer 1

SELECT uid, COUNT(*) FROM table WHERE fid=1 AND `time` > 9 GROUP BY uid