sql纵向,横向,去Null值,去0值求平均数
sql纵向,横向,去Null值,去0值求平均数sql纵向,横向,去Null值,去0值求平均数
sql纵向,横向,去Null值,去0值求平均数
SELECT
round( avg( nullif( temperature, 0 )), 2 ) temperature,
sum( electricity_sum + electricity_1 + electricity_2 + electricity_3 ) AS electricity_sum,
sum( power_sum ) AS power_su
原创
2022-04-18 20:09:36 ·
906 阅读 ·
0 评论