文件名称:聚合函数-SUM、AVG、MAX、MIN-SQL入门教程
文件大小:14.58MB
文件格式:PPT
更新时间:2024-05-13 18:31:03
SQL入门
聚合函数-SUM、AVG、MAX、MIN 1、SUM 2、AVG 3、MAX和MIN SELECT SUM(Upoint) as 总积分 FROM Customers SELECT AVG(upoint) as 平均积分 FROM Customers SELECT MAX(upoint) as 最高积分, MIN(upoint) as 最低积分 FROM Customers