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 ·
793 阅读 ·
0 评论