大牛们,看过来
我有一个表 里面有四列BY TYPENAME,EnterpriseArea,CheckEnterprise,adname,我要取到按每个字段加一个字段的分组数量,有没有比较简便的写法,我下面的写法取到是零散的,而且要有10个字段我得连到啥时候去啊,请大牛们指点
SELECT TYPENAME ,COUNT(TYPENAME)as typecount
FROM #tempa
GROUP BY (TYPENAME)
SELECT TYPENAME+EnterpriseArea ,COUNT(TYPENAME+EnterpriseArea)as Areacount
FROM #tempa
GROUP BY TYPENAME+EnterpriseArea
SELECT TYPENAME+EnterpriseArea+CheckEnterprise,COUNT(TYPENAME+EnterpriseArea+CheckEnterprise)as Areacount
FROM #tempa
GROUP BY TYPENAME+EnterpriseArea+CheckEnterprise
SELECT TYPENAME+EnterpriseArea+CheckEnterprise+adname,COUNT(TYPENAME+EnterpriseArea+CheckEnterprise+adname)as Areacount
FROM #tempa
GROUP BY TYPENAME+EnterpriseArea+CheckEnterprise+adname