SELECT COUNT(*) AS CNT,str(DATEPART(year, postTime))+str(DATEPART(month, postTime)) as ym
FROM contentArticle
GROUP BY str(DATEPART(year, postTime))+str(DATEPART(month, postTime))
得到的结果将是
CNT | ym |
3 | 2006 4 |
SELECT COUNT(*) AS CNT,str(DATEPART(year, postTime))+str(DATEPART(month, postTime)) as ym
FROM contentArticle
GROUP BY str(DATEPART(year, postTime))+str(DATEPART(month, postTime))
得到的结果将是
CNT | ym |
3 | 2006 4 |