曾经查询一年中每月数据数量都要SELECT COUNT(0) FROM TABLE1 循环N次。。。最近突然发现GROUP BY的妙用。所以。。
SELECT
datepart(yyyy,@time) as year,
datepart(mm,@time) as month,
count(0) as count
FROM TABLE1
GROUP BY datepart(yyyy,@time),datepart(mm,@time)
ORDER BY datepart(yyyy,@time),datepart(mm,@time)
像这种奇妙用途的函数datepart,还是很多的,datediff()等,恩恩,记录下来。新手新手,学习笔记,各位看官勿喷。