请教SQL 如何查询同一id下的各条号码出现次数?
例:
id calls
20181025 123
20181025 123
20181025 123
20181025 124
20181025 124
20181025 125
20181026 123
20181026 123
20181026 124
20181026 125
20181026 125
20181026 125
20181026 125
20181027 123
20181027 124
20181027 125
期望返回结果:
20181025 123 3
20181025 124 2
20181025 125 1
20181026 123 2
20181026 124 1
20181026 125 4
20181027 123 1
20181027 124 1
20181027 125 1