网站建设模板套用,南京网页空间,免费制作宣传册的app,微信商城购物有保障吗66.Oracle数据库SQL开发之 高级查询——使用线性回归函数线性回归函数可以用普通最小平方回归曲线拟合一组数值对。线性回归函数可用于聚合、串口或报表函数。如下图1#xff1a;例如#xff1a;storePDB1 selectprd_type_id,regr_avgx(amount,month) as avgx,regr_avgy(…66.Oracle数据库SQL开发之 高级查询——使用线性回归函数线性回归函数可以用普通最小平方回归曲线拟合一组数值对。线性回归函数可用于聚合、串口或报表函数。如下图1例如storePDB1 selectprd_type_id,regr_avgx(amount,month) as avgx,regr_avgy(amount,month) as avgy,regr_count(amount,month) as count,regr_intercept(amount,month) as inter,regr_r2(amount,month) as r2,regr_slope(amount,month) as slope,regr_sxx(amount,month) as sxx,regr_sxy(amount,month) as sxy,regr_syy(amount,month) as syyfromall_saleswhereyear2003 group by prd_type_id;PRD_TYPE_ID AVGX AVGY COUNT INTER R2 SLOPE SXX SXY----------- ---------- -------------------- ---------- ---------- ---------- ---------- ----------SYY----------1 6.5 12570.5811 72 13318.4543 .003746289-115.05741 858 -98719.2630319027172 6.5 2588.62806 72 2608.11268 .0000508 -2.997634 858 -2571.971517673925 04 6.5 5593.76611 72 2043.47164 .128930297546.199149 858 468638.8719853374883 6.5 6642.65153 72 2154.23119 .126338815690.526206 858 592471.4853238253324
