葵花牌、阳光

摘要： 先说结论：avg函数求平均值时，空值不参与统计。 示例数据： with tmp as ( select 1 as id ,100 as value union all select 2 as id ,null as value union all select 3 as id ,200 as val 阅读全文