数据库有张表,n行,20列,我写了一个存储过程,希望求出每一行的平均值,但是每次求的都是最后一行的平均值,前面的每行平均值怎么求啊?这是我的存储过程的部分
as
select @al= (SELECT
AVG(col)
FROM(
SELECT col = f1 UNION ALL
SELECT col = f2 UNION ALL
SELECT col = f3 UNION ALL
SELECT col = f4 UNION ALL
SELECT col = f5 UNION ALL
SELECT col = f6 UNION ALL
SELECT col = f7 UNION ALL
SELECT col = f8 UNION ALL
SELECT col = f9 UNION ALL
SELECT col = f10 UNION ALL
SELECT col = f11 UNION ALL
SELECT col = f12 UNION ALL
SELECT col = f13 UNION ALL
SELECT col = f14 UNION ALL
SELECT col = f15 UNION ALL
SELECT col = f16 UNION ALL
SELECT col = f17 UNION ALL
SELECT col = f18 UNION ALL
SELECT col = f19 UNION ALL
SELECT col = f20
)A
)
FROM SCMData
as
select @al= (SELECT
AVG(col)
FROM(
SELECT col = f1 UNION ALL
SELECT col = f2 UNION ALL
SELECT col = f3 UNION ALL
SELECT col = f4 UNION ALL
SELECT col = f5 UNION ALL
SELECT col = f6 UNION ALL
SELECT col = f7 UNION ALL
SELECT col = f8 UNION ALL
SELECT col = f9 UNION ALL
SELECT col = f10 UNION ALL
SELECT col = f11 UNION ALL
SELECT col = f12 UNION ALL
SELECT col = f13 UNION ALL
SELECT col = f14 UNION ALL
SELECT col = f15 UNION ALL
SELECT col = f16 UNION ALL
SELECT col = f17 UNION ALL
SELECT col = f18 UNION ALL
SELECT col = f19 UNION ALL
SELECT col = f20
)A
)
FROM SCMData
解决方案 »
- 截取字符串问题
- [讨论]大家的服务器都是7×24小时运行吗?
- 合并列的SQL,请帮帮我
- 用虚拟光驱打开sql2000.iso安装文件后,没有弹出安装界面呀?提示,某个quicktime软件已过期!我重新下了个quicktime安装后还不行?
- SSRS 如何动态的 显示 或者 隐藏 表格,谢谢啊
- 数据库表不能被访问/更新
- 继续问一个Group by的问题。
- 一句select 能实现,查数据时加上自动序列号吗?
- 关于COMPUTE 的问题...急.......
- java数据库中计算出来的百分比怎么显示在前台页面上
- 请教SQL按时间值关联数据的问题
- 请问这样的约束应该如何写?我读了好几本SQL编程书都没看到
from SCMData
select col=f1,no union select col=f2,no....group by no
select avg(f1+f2+f3+f4+f5+f6+f7+f8+f9+f10+f11+f12+f13+f14+f15+f16+f17+f18+f19+f20) from SCMData with(nolock)