select count(*) N'总行数'
from
(
    select [字段] from [表]
    group by [字段]
) t

select [字段],count(*) N'分组行数' from [表]
group by [字段]

------解决方案--------------------
表别名，结果集做表.
探讨

引用:
SQL code

select count(*) N'总行数'
from
(
select [字段] from [表]
group by [字段]
) t



这最后面加个t是什么意思啊？