各位给看看如何将表中重复行数据统计出来

[RainSmall]

值日表 zrb

值日人 people，房间 号 roomnum

表数据如下

people roomnum

A 1
A 1
B 3
A 4
B 3
B 2
C 1
C 2

要求实现如下统计

people roomnum count
A 1 2
A 4 1
B 2 1
B 3 2
C 1 1
C 2 1

值日人，房间号都是不定的，大家给看看啊

[bw555]

select people,roomnum,COUNT(1) AS    count
from ZRB
GROUP BY people,roomnum

[RainSmall]

引用 1 楼 bw555 的回复:

select people,roomnum,COUNT(1) AS    count
from ZRB
GROUP BY people,roomnum

意思是把people,roomnum作为联合字段进行分组了吗

[bw555]

引用 2 楼 zhishangwuzhe 的回复:

[quote=引用 1 楼 bw555 的回复:]

select people,roomnum,COUNT(1) AS    count
from ZRB
GROUP BY people,roomnum

意思是把people,roomnum作为联合字段进行分组了吗[/quote] 没错，很基础的应用

[RainSmall]

引用 3 楼 bw555 的回复:

[quote=引用 2 楼 zhishangwuzhe 的回复:] [quote=引用 1 楼 bw555 的回复:]

select people,roomnum,COUNT(1) AS    count
from ZRB
GROUP BY people,roomnum

意思是把people,roomnum作为联合字段进行分组了吗[/quote] 没错，很基础的应用[/quote] 嗯呢，谢谢了