2022软考初级模拟考试冲刺试题285

1. [单选题]学生选课的关系模式为SC(SN,CN,SM)，其中SN为学号，CN为课程号，SM为成绩。检索选修3门以上课程的学生总成绩，并按总成绩的降序排列。 SELECT SN,SUM(SM) FROM SC ______0RDER BY 2 DESC;

A. GROUP BY SN HAVING COUNT(*)＞=3
B. HAVINGCOUNT(*)＞=3 GROUP BY SN
C. GROUP BY SM HAVING COUNT(*)＞=3
D. HAVING COUNT(*)＞=3 GROUP BY SM

查看答案&解析查看所有试题

本文链接：https://www.51ksbd.net/show/e53zpe.html