declare @deptcode varchar(4),
@startdate datetime,
@enddate datetime
set @deptcode = '0201'
set @startdate = '2016-07-01 00:00'
set @enddate = '2016-07-22 23:59'
SELECT c.stddeptcode,
c.stddeptname,
sum(a.actualmoney) as '销售额',
count(distinct a.flowno) as '客流量',
convert(decimal(18,2),round(sum(a.actualmoney)/count(distinct a.flowno),2)) as '客单价'
FROM inf_gdscode b
left join acc_goodsflow a on b.gdscode = left(a.gdssalecode,8)
and a.deptcode = @deptcode
and a.saletime >= @startdate
AND a.saletime <= @enddate
left join inf_stddept c on b.stddept = c.stddeptcode
where c.stddeptcode in (21,22,23)
group by c.stddeptcode,
c.stddeptname
这个语句还有没有优化的空间了
c.stddeptcode in (21,22,23)这句能不能用Exists进行过滤
