01 2024 档案

摘要:先说结论: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 阅读全文
posted @ 2024-01-18 10:12 葵花牌、阳光 阅读(193) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示