avg函数忽略null值

2018-06-05 mysql Comments Word Count: 25words Read Count: 1minutes

avg函数对值为null的行，会忽略不计解决方案

    avg((coalesce(column,0))

Permalink: https://blog.tianshiming.com/2018/06/avg-ignore-null/

License：CC BY 4.0 CN

Finally