请教此查询语句。大家给看看。
运行此语句
SELECT * FROM _Inventory where ItemID in (select ID64 from _Items WHERE (MagParamNum =6 ) AND (MagParam1 > 0) )
ORDER BY CharID
结果如下：

ID SOLT ITEMID

31069191267742
31069141398592
31069671433251
3108761278191
3109661389209
31096581311753
31103241287728
3110711458125
3112061435518
3112561365861
3113541387962
3113511293904
3113501350325
3116361372314
3121041369660
3121001378087

我现在想把查询出来ID能自动显示数量。就是多少个ID 符合查询语句规则。不需要显示出来具体的ITEMID数字。以上面为例，能直接显示出 ID=31069 共3个，ID=31087 共一个 ID=31096共2个等等。。 直接查询出ID后面显示出数量。

该怎么写查询语句？

[解决办法]
with tb as
(
SELECT * FROM _Inventory where ItemID in (select ID64 from _Items WHERE (MagParamNum =6 ) AND (MagParam1 > 0) )
ORDER BY CharID
)
select ID, count(1)
from tb
group by ID
[解决办法]

SQL code

select id,count(1)  from (SELECT * FROM _Inventory where ItemID in (select ID64 from _Items WHERE (MagParamNum =6 ) AND (MagParam1 > 0) ) ) group by id