select CASE MONTH(OccurenceDate)
WHEN MONTH(2003-01-17) THEN OccurenceQty ELSE 0 END as n12, OccurenceCode
from t_Summary where InOutName='1'
以上只是对所有的一月份进行了统计,如何实现年份的比较?
如以上的例子:比较的是2003年1月份。
(要求不能在where中写语句。。。。)
...全文
455打赏收藏
如何实现同时对时间,年份机型比较?---在线等待。
select CASE MONTH(OccurenceDate) WHEN MONTH(2003-01-17) THEN OccurenceQty ELSE 0 END as n12, OccurenceCode from t_Summary where InOutName='1' 以上只是对所有的一月份进行了统计,如何实现年份的比较? 如以上的例子:比较的是2003年1月份。 (要求不能在where中写语句。。。。)
select CASE WHEN YEAR(OccurenceDate)=YEAR('2003-01-17') and MONTH(OccurenceDate)=MONTH('2003-01-17') THEN OccurenceQty ELSE 0 END as n12, OccurenceCode
from t_Summary where InOutName='1'
select CASE WHEN YEAR(OccurenceDate)=YEAR('2003-01-17') and MONTH(OccurenceDate)=MONTH('2003-01-17') THEN OccurenceQty ELSE 0 END as n12, OccurenceCode
from t_Summary where InOutName='1'
select CASE WHEN YEAR(OccurenceDate)=YEAR(2003-01-17) and MONTH(OccurenceDate)=MONTH(2003-01-17) THEN OccurenceQty ELSE 0 END as n12, OccurenceCode
from t_Summary where InOutName='1'