avg(case when isnull(a.num,0)=0 then 0 else cast(isnull(d.counts,0) as DECIMAL)/cast(isnull(a.num,0) as DECIMAL)end) result
数据库 字段不为空计算
于 2023-06-02 18:08:59 首次发布
avg(case when isnull(a.num,0)=0 then 0 else cast(isnull(d.counts,0) as DECIMAL)/cast(isnull(a.num,0) as DECIMAL)end) result