针对学生选课表sc（sno, cno, grade），其中sno为学号，cno为课程号，grade为成绩。以下（）语句可查询选修了两门以上成绩在90分以上课程的学生学号。 A: select snofrom scwhere grade>;90group by snohaving count(cno)>;2 B: select snofrom scwhere grade>;90group by snohaving count(*)>;2 C: select snofrom scwhere grade>;90 and count(*)>;2group by sno D: select snofrom scwhere grade>;90group by snohaving count(distinct sno)>;2

针对学生选课表sc（sno, cno, grade），其中sno为学号，cno为课程号，grade为成绩。以下（ ）语句可查询选修了两门以上成绩在90分以上课程的学生学号。 A: select sno from scwhere grade>90group by snohaving count(cno)>2 B: select sno from scwhere grade>90group by snohaving count(*)>2 C: select sno from scwhere grade>90 and count(*)>2group by sno D: select sno from scwhere grade>90group by snohaving count(sno)>2

针对学生选课表sc（sno, cno, grade），其中sno为学号，cno为课程号，grade为成绩。以下（ ）语句可查询选修了两门以上成绩在90分以上课程的学生学号。 A: select sno from sc where grade>90 group by sno having count(cno)>2; B: select sno from sc where grade>90 group by sno having count(*)>2; C: select sno from sc where grade>90 and count(*)>2 group by sno; D: select sno from sc where grade>90 group by sno having count(sno)>2;

关系SC(Sno，Cno，Grade)表示学号，课程号，成绩。现要查询平均分在90分以上的学生的学号和平均成绩，正确的语句是______。 A: SELECT Sno，AVG(Grad FROM SC WHERE AVG(Grad＞=90 GROUP BY Sno B: SELECT Sno，AVG(Grad FROM SC GROUP BY Sno HAVING AVG(Grad＞=90 C: SELECT Sno，AVG(Grad FROM SC WHERE AVG(Grad＞=90 ORDER BY Sno D: SELECT Sno，AVG(Grad FROM SC GROUP BY Cno HAVING AVG(Grad＞=90

EXW is the only term in Group E, _________, __________, __________ in Group F, _________, __________, __________, ___________ in Group C, and _________, __________, __________ in Group D.

args) { Group group=new Group(); Person per

When both anti-A and anti-B agglutinins are present in the plasma,<br/>the blood will be ___. () A: group A B: group B C: group O D: group AB E: group B or group AB

企业资源计划（ERP）是由美国著名的咨询公司Gartner Group公司于20世纪90年代初首先提出的。

对查询结果分组使用的关键字是( ) A: group B: group with C: group by D: group of

如果查询的select子句为select A,B,C*D ，则不能使用的group by子句是（C）。A. group by AB. group by A,BC. group by A,B,C*DD. group by A,B,C,D A: group by A B: group by A,B C: group by A,B,C*D D: group by A,B,C,D