SELECT MainMan,SUM(TranAllowance) AS TranAllowancesum,
SUM(BasMainService) AS BasMainServicesum,
SUM(FastService) AS FastServicesum,
SUM(DeskService) AS DeskServicesum,
SUM(McDonService) AS McDonServicesum,
SUM(ServerService) AS ServerServicesum,
SUM(NetworkService) AS NetworkServicesum,
SUM(VulnSystemIntegServices) AS VulnSystemIntegServicessum,LEFT(CONVERT(varchar(100), DisDate, 20),7) AS Time FROM TestTable
WHERE dateadd(dd,-day(getdate())+1,getdate()) AND dateadd(dd,-day(getdate()),dateadd(m,1,getdate())) GROUP BY MainMan,LEFT(CONVERT(varchar(100), DisDate, 20),7)
在RoadFlow 我需要查询日期范围的内容
我查询的时候会显示查询错误 求大神解答!
相关分类