菜鸟高分求一条简单的查询语句

[我是来接分的]

现有表
+----+---------+--------+----------+------------+--------------+----------+-----------------+
| id | acty_id | inv_id | inved_id | inv_status | inved_status | winer_id | acty_start_time |
+----+---------+--------+----------+------------+--------------+----------+-----------------+
| 7 | 613 | 8 | 45 | 1 | 0 | 8 | 346867060 |
| 6 | 612 | 8 | 22 | 0 | 0 | 0 | 346867060 |
| 5 | 600 | 8 | 11 | 0 | 0 | 0 | 346867060 |
| 4 | 611 | 8 | 67 | 0 | 0 | 0 | 346867060 |
| 23 | 712 | 8 | 11 | 0 | 0 | 0 | 347992267 |
| 22 | 671 | 8 | 11 | 2 | 0 | 11 | 347730317 |
| 10 | 621 | 8 | 22 | 1 | 2 | 8 | 346867060 |
| 11 | 635 | 8 | 11 | 0 | 0 | 0 | 347113358 |
| 12 | 641 | 8 | 22 | 0 | 0 | 0 | 347113358 |
| 21 | 684 | 8 | 11 | 2 | 0 | 11 | 347730317 |
| 14 | 632 | 8 | 67 | 0 | 0 | 0 | 347113358 |
| 20 | 687 | 8 | 11 | 1 | 0 | 8 | 347730317 |
| 16 | 651 | 8 | 11 | 1 | 0 | 8 | 347730317 |
| 17 | 631 | 8 | 11 | 1 | 0 | 8 | 347730317 |
| 25 | 512 | 8 | 11 | 0 | 0 | 0 | 347992267 |
| 24 | 722 | 8 | 11 | 1 | 0 | 8 | 347992267 |
| 26 | 532 | 8 | 11 | 0 | 0 | 0 | 347992267 |
| 27 | 899 | 217 | 11 | 1 | 0 | 217 | 348349500 |
| 28 | 900 | 8 | 45 | 1 | 0 | 8 | 348403500 |
| 29 | 900 | 8 | 56 | 1 | 0 | 8 | 348403500 |
| 30 | 901 | 666 | 22 | 0 | 0 | 0 | 348324300 |
| 31 | 902 | 8 | 88 | 2 | 0 | 88 | 348489900 |
| 32 | 915 | 777 | 127 | 0 | 0 | 0 | 348324300 |
| 33 | 916 | 721 | 22 | 0 | 0 | 0 | 348336000 |
| 34 | 922 | 721 | 171 | 0 | 0 | 0 | 348425100 |
| 35 | 921 | 721 | 678 | 0 | 0 | 0 | 348414300 |
| 41 | 954 | 8 | 67 | 0 | 0 | 0 | 351185070 |
| 37 | 931 | 543 | 45 | 2 | 1 | 45 | 348608700 |
| 38 | 932 | 965 | 11 | 2 | 0 | 11 | 348605100 |
| 39 | 933 | 756 | 67 | 0 | 0 | 0 | 348601500 |
| 40 | 949 | 109 | 8 | 2 | 0 | 8 | 349037100 |
+----+---------+--------+----------+------------+--------------+----------+-----------------+
查询的不重复inv_id
select distinct inv_id from BattleScore ;
+--------+
| inv_id |
+--------+
| 8 |
| 217 |
| 666 |
| 777 |
| 721 |
| 543 |
| 965 |
| 756 |
| 109 |
+--------+
查询每个inv_id对应的记录数count
select distinct inv_id,(select count(1) from BattleScore where inv_id=....) from BattleScore ;

这个该怎么查...第一个查出来的inv_id的值为子查询的条件 得出下面这样的:

+--------+
| inv_id | 对应的记录数
+--------+
| 8 | 23
| 217 | 1
| 666 | ...
| 777 | ...
| 721 |
| 543 |
| 965 |
| 756 |
| 109 |
+--------+

[ycproc]

[子夜__]

[silentcross]

select inv_id, count(*) from BattleScore group by inv_id

[huangwenquan123]

create table ceshi(ivid int not null)
insert into ceshi(ivid) values(1)
insert into ceshi(ivid) values(1)
insert into ceshi(ivid) values(2)
insert into ceshi(ivid) values(2)
insert into ceshi(ivid) values(2)
insert into ceshi(ivid) values(3)

select ivid from ceshi
select ivid,count(1) from ceshi group by ivid

[huangwenquan123]

/*
字段自己改下，其实就分组统计就可以
结果
1	2
2	3
3	1
*/

[qiudong_5210]

--试下看看
select distinct inv_id,count(inv_id) as ArticleCount 
from BattleScore
group by inv_id
order by inv_id