select id, (col1+col2+ col3)/3 as avgVal from T1 where id=123
select tn.date,case when tn.type=a then avg(tn.value) end as 'a',case when tn.type=b then avg(tn.value) end as 'b' from table_name tn group by tn.date简单的叙述了下。可能有漏考虑的勿怪
欢迎分享,转载请注明来源:内存溢出
select id, (col1+col2+ col3)/3 as avgVal from T1 where id=123
select tn.date,case when tn.type=a then avg(tn.value) end as 'a',case when tn.type=b then avg(tn.value) end as 'b' from table_name tn group by tn.date简单的叙述了下。可能有漏考虑的勿怪
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)