SQL 按月分组日期 [英] SQL group dates by month
本文介绍了SQL 按月分组日期的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个返回到期日期的查询:
I have a query that returns expiration dates:
SELECT ci.accountnumber
, ci.accountname
, cvu.ExpirationDate
FROM dbo.clientinfo ci
INNER JOIN clientvehicleunit cvu ON ci.clientid = cvu.clientid
到期日期可以是任何月份和任何年份的任何时间.
The expiration dates can be anytime during any month and any year.
我需要返回 12 个月内每个月内到期的商品数量....
I need to return counts of how many units are due to expire within each month for a 12 month period....
我不知道该怎么做?
推荐答案
你可以这样做:
例如有多少单位将于 2012 年到期:
e.g. how many units are due to expire in 2012:
SELECT MONTH(cvu.ExpirationDate) AS Mnth, YEAR(cvu.ExpirationDate) AS Yr,
COUNT(*) AS DueToExpire
FROM clientvehicleunit cvu
WHERE cvu.ExpirationDate >= '20120101' AND cvu.ExpirationDate < '20130101'
GROUP BY MONTH(cvu.ExpirationDate), YEAR(cvu.ExpirationDate)
这篇关于SQL 按月分组日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文