oracle中的样本差怎么计算-----样本标准差和全数据标准差两种
select
STDDEV(b.sectionscore) s,---------------这里是样本标准差不是全部数据的
STDDEV(b.sectionscore) s,---------------这里是样本标准差不是全部数据的
STDDEV_POP(b.sectionscore) s,---------------这个是所有数据的标准差
from subjectregister aleft join subjectsectionscore b
on a.sid = b.subjectregistersid
left join subjectsection c
on b.sectionsid = c.sid
where a.score != '0'
and a.score IS NOT null
and a.subjectcode != 'F'
and a.subjectcode != 'S'
AND
