sql分组后，查看分组内部得类别数量（多层分组）

使用子查询，多层group by思路来解决

select tmp.Line_Code, count(*)
from (select Bus_Code, Line_Code from Suqian_data.dbo.DD_Real_Time_Detail group by Line_Code, Bus_Code) tmp
group by tmp.Line_Code