select o.SF_ID,NAME,COUNT(sf_id) sum,COUNT(case when o.ORDER_STATUS like 'YWC%' then 1 end) finish
from COM_ORDER o left join COM_SHIFU s on o.SF_ID = s.ROW_ID
where DateDiff(dd,UP_ORDER_TIME,getDate())= 0 group by o.SF_ID,NAME having COUNT(SF_ID) != 0
and NAME != '' and SF_ID is not null
一个SQL中有2个聚合函数
最新推荐文章于 2022-04-22 13:28:29 发布