10聚合函数

最新推荐文章于 2024-11-29 19:01:27 发布

巧克力豆儿本豆

最新推荐文章于 2024-11-29 19:01:27 发布

阅读量316

点赞数 1

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/weixin_36024609/article/details/53305172

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [Id]
      ,[StudentNo]
      ,[SubjectId]
      ,[StudentResult]
      ,[ExamDate]
  FROM [MySchool].[dbo].[Result]
  
  ----SUM   总
  SELECT SUM(SubjectId) AS 哈哈 
  FROM [MySchool].[dbo].[Result]
  WHERE StudentResult=80
  
  
  
  --AVG   平均
  SELECT AVG(StudentResult) AS 哈哈 
  FROM [MySchool].[dbo].[Result]
  WHERE SubjectId=3
  
  
  --MAX   最大
  SELECT MAX(StudentResult) AS 哈哈 
  FROM [MySchool].[dbo].[Result]
  WHERE SubjectId=3
  
  
  --MIN   最小
   SELECT MIN(StudentResult) AS 哈哈 
  FROM [MySchool].[dbo].[Result]
  WHERE SubjectId=3
  
  
  --GOUNT   份
  SELECT GOUNT(*) AS 哈哈 
  FROM [MySchool].[dbo].[Result]