Sql在Group by的select中包含多列 

SELECT  A ,
        B ,
        COUNT(Id) AS '数量'
FROM    dbo.[Table]
GROUP BY A ,
        B

 

posted @ 2015-01-18 22:29  astrue  阅读(1055)  评论(0)    收藏  举报