select 单位 as 码头,
sum(case when datediff(day,时间,getdate()) = 0 then 销售数量 else 0 end) as [销售数量(当天)],
sum(case when datediff(month,时间,getdate()) = 0 then 销售数量 else 0 end) as [销售数量(当月)]
from 表
group by 单位
sum(case when datediff(day,时间,getdate()) = 0 then 销售数量 else 0 end) as [销售数量(当天)],
sum(case when datediff(month,时间,getdate()) = 0 then 销售数量 else 0 end) as [销售数量(当月)]
from 表
group by 单位
(select 单位,sum(销售数量) as 当天销售数量 from 表 where day(时间)=day(getdate()) and month(时间)=month(getdate()) and year(时间)=year(getdate())) b
on b.单位=a.单位 left join
(select 单位,sum(销售数量) as 当月销售数量 from 表 where month(时间)=month(getdate()) and year(时间)=year(getdate())) c on c.单位=a.单位