34,590
社区成员
发帖
与我相关
我的任务
分享
-- try
select year(submittime) as y, month(submittime ) as m , day(submittime) as d, sum(isnull(m.mobcount,0)) as mobcount from Jp_SMSInfo s
left join Jp_MobBook m on m.bookid = s.id
group by year(submittime) , month(submittime ) , day(submittime)
select day(submittime) '日期',sum(mobcount)'提交条数' from Jp_MobBook a join Jp_SMSInfo b on a.ID=b.BookID group by convert(varchar(10),submittime,120),day(submittime)