初学者，有个sql语句写不出来，请帮忙看看

[ascmvi]

假设我在给别人发钞票。每次来人就给一元。
建表send，只有一个字段，id 表示每个人的id。

发了几天终于发完了，现在我想统计来领了1次的人有多少，领了两次的人有多少，领了5次的人有多少？？？
该怎么写呢 ？？？？？？？？？？？？？？？？？？？？？？？？

[jacobsan]

select id,count(1) as 次数 from tablename group by id

[jacobsan]

select 次数,count(1) from (select id,count(1) as 次数 from tablename group by id) t group by 次数

[mengmou]

就这么写。

[zsl5305256]

select count(*) from send group by id having count(*)=1 or having count(*)=2 or having count(*)=5

[yudi010]

select id,count(1) as 次数 from tablename group by id

[wangdehao]

select id,count(*) as 次数
from tb group by id
having count(*)=?

[paoluo]

Create Table TEST(ID Int)
Insert TEST Select 1
Union All Select 2
Union All Select 3
Union All Select 2
Union All Select 3
Union All Select 1
Union All Select 5
Union All Select 3
Union All Select 7
GO
Select 次數, Count(*) As 人數 From
(
Select ID, Count(*) As 次數 From TEST Group By ID) A
Group By 次數
Order By 次數
Go
Drop Table TEST
/*
次數 人數
1 2
2 2
3 1
*/

[DavidNoWay]

正解

[子陌红尘]

select
a.times,count(1) as num
from
(select count(*) as times from tname group by id) a
group by
a.times

[一者仁心]

select id from send group by id having count(1)=领取次数

[hrb2008]

支持
Create Table TEST(ID Int)
Insert TEST Select 1
Union All Select 2
Union All Select 3
Union All Select 2
Union All Select 3
Union All Select 1
Union All Select 5
Union All Select 3
Union All Select 7
GO
Select 次數, Count(*) As 人數 From
(
Select ID, Count(*) As 次數 From TEST Group By ID) A
Group By 次數
Order By 次數
Go
Drop Table TEST
/*
次數 人數
1 2
2 2
3 1
*/