【文件属性】:
文件名称:聚合函数--SqlServer教材,基础学习(基础篇)
文件大小:4.56MB
文件格式:PPT
更新时间:2021-04-25 22:08:50
SqlServer
聚合函数-1
SUM
AVG
×
SELECT SUM(ytd_sales) FROM titles WHERE type = 'business'
SELECT SUM(ytd_sales) ,Price
FROM titles WHERE type = 'business'
SELECT AVG(SCore) AS 平均成绩
From Score WHERE Score >=60