摘要:
曾经查询一年中每月数据数量都要SELECT COUNT(0) FROM TABLE1 循环N次。。。最近突然发现GROUP BY的妙用。所以。。 SELECT datepart(yyyy,@time) as year,datepart(mm,@time) as month,count(0) as countFROM TABLE1GROUP BY datepart(yyyy,@time),datepart(mm,@time) ORDER BY datepart(yyyy,@time),datepart(mm,@time) 像这种奇妙用途的函数datepart,还是很多的,datediff... 阅读全文