聚集函数会在统计时会考虑空值的情况，哪些不会考虑空值？

总结：在聚合函数中遇到空值时，除了COUNT(*)外，都跳过空值而去处理非空值。

sum() avg() 会忽略空值，count(某一字段也会忽略空值)

（1）avg举例：

select  department_id, training_months from liuhx1 where department_id='90'

运行结果：
DEPARTMENT_ID  TRAINING_MONTHS
90
90                2
90                2


select DEPARTMENT_ID,
avg(nvl(TRAINING_MONTHS,0)),
avg(TRAINING_MONTHS) 
from liuhx1 
where DEPARTMENT_ID ='90'
group by DEPARTMENT_ID  

运行结果：
DEPARTMENT_ID  AVG(NVL(TRAINING_MONTHS,0))     AVG(TRAINING_MONTHS)
90               1.333                            2

（2）count(*)  count(某一字段)举例

select count(*) from liuhx1
运行结果：107
select count(COMMISSION_PCT) from liuhx1
运行结果：35