sqlserver中求平均值跟求和语句

[mss1029]

给个具体例子

[woshisqlaihaozhe]

column--列名
tablename--表名

select sum(column) from tablename
select avg(column) from tablename

[gahade]

select avg(数值列),sum(数值列) from 表

[gahade]

具体看SQLSERVER联机帮助,很详细

[mss1029]

谢谢

[hyde100]

select 分组列,
avg(数值列) as 平均值,
sum(数值列) as 求和
from 表
group by 分组列

[水族杰纶]

---到PUBS數據庫感受下
USE pubs
GO
-- Aggregate functions
SELECT type, SUM(price), SUM(advance)
FROM titles
WHERE type LIKE '%cook'
GROUP BY type
ORDER BY type
GO
------------------------------------
USE pubs

SELECT AVG(advance), SUM(ytd_sales)
FROM titles
WHERE type = 'business'