上面那个可能不对,你看一下这个吧,我没有调试过,有问题再联系,guxizhw@sina.com
Dim strWhere As String
Dim strSQL As String
Dim rs As New ADODB.Recordset
Dim arr() As String
strWhere = " WHERE 专业='专业1' AND 年级='年级1' AND 班级='班级1' AND 课程='课程1'"
strSQL = "SELECT SUM(CASE WHEN 成绩>=90 AND 成绩<100 THEN 成绩 ELSE 0 END) AS L90Above," _
& "SUM(CASE WHEN 成绩>=80 AND 成绩<90 THEN 成绩 ELSE 0 END) AS L80To90," _
& "SUM(CASE WHEN 成绩>=70 AND 成绩<80 THEN 成绩 ELSE 0 END) AS L70To80," _
& "SUM(CASE WHEN 成绩>=60 AND 成绩<70 THEN 成绩 ELSE 0 END) AS L60To70," _
& "SUM(CASE WHEN 成绩<60 THEN 成绩 ELSE 0 END) AS L50Low,Count(学号) AS StudentNum FROM 表名 " _
'表中有:专业,年级,班级,学号,姓名,课程,成绩几个列属性!!希望大虾指点一下!
Dim strWHERE As String
Dim strSQL As String
Dim rs As New ADODB.Recordset
Dim arr() As String
strWHERE = " WHERE 专业='专业1' AND 年级='年级1' AND 班级='班级1' AND 课程='课程1'"
strSQL = "SELECT SUM(CASE WHEN 成绩>=90 AND 成绩<100 THEN 成绩 ELSE 0 END) AS L90," _
& "SUM(CASE WHEN 成绩>=80 AND 成绩<90 THEN 成绩 ELSE 0 END) AS L80," _
& "SUM(CASE WHEN 成绩>=70 AND 成绩<80 THEN 成绩 ELSE 0 END) AS L70," _
& "SUM(CASE WHEN 成绩>=60 AND 成绩<70 THEN 成绩 ELSE 0 END) AS L60," _
& "SUM(CASE WHEN 成绩<60 THEN 成绩 ELSE 0 END) AS LBadStudent " _