摘要:
SELECT year(fCreatTime)as 年份,sum (case when fLeiBie='1' then 1 else 0 end) as 报修,sum(case when fLeiBie='2' then 1 else 0 end) as 咨询,sum(case when fLei 阅读全文
摘要:
昨天 select * from tb where datediff(day, 时间字段 ,getdate()) = 1 今天 select * from tb where datediff(day, 时间字段 ,getdate()) = 0 本周 select * from tb where da 阅读全文