关于数据库行数查询解决方法

select count(*) N'总行数'from(    select [字段] from [表]    group by [字段]) tselect [字段],count(*) N'分组行数' from [表]group by [字段]
------解决方案--------------------
表别名，结果集做表.
探讨

引用:
SQL code

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



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