比如物料名称选择小径杂木和小径杨木,挂牌价就是小径杂木一级、二级两个数与小径杨木一级、二级两个数,共4个数之和再除以4。随着选择物料名称不同,显示的数也会有变化。
AVG不对?还是数据库没avg()?
--------
SELECT wldj,AVG(MATERIAL_PRICE) [AVG_] FROM TABLE WHERE 1=1 ${len(控件名称)==0,""," and wlmc in ('"+控件名称+"')"} group by wldj