摘要：--一个sql 使用 group by 实现 4个 sql 的效果 select ProjectNumber,ClientName,jx,sf,sum(count) as TotalCount from tlog where StDate>='2017-10-01' and StDate='2017-10-01' and StDate='2017-10-... 阅读全文

摘要：declare @endtime datetime declare @starttime datetime set @starttime='2017-09-01' set @endtime = '2017-11-24' declare @ctime datetime select @ctime= dateadd(SECOND,convert(int,(rand()*datediff(SECO... 阅读全文