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