LC和SC分别具有几个工作站系统（） A: LC:3,SC:3 B: LC:4,SC:2 C: LC:2,SC:4 D: LC:4,SC:3

不戴镜，远距测定内隐斜2△，近距测定外隐斜3△，记录为（）。 A: CC：E2△X’3△ B: SC：E2△X’3△ C: SC：X2△X’3△ D: SC：E2△E’3△

“查询选修了3门以上课程的学生的学生号”，正确的SQL语句是( )。 A: SELECT S#FROM SC GROUP BY S#WHERE COUNT(*)>3 B: SELECT S#FROM SC GROUP BY S#HAVING COUNT(*)>3 C: SELECT S#FROM SC ORDER BY S#HAVING COUNT(*)>3 D: SELECT S#FROM SC ORDER BY S#WHERE COUNT(*)>3

下列查询语句中，错误的是（）。 A: ASELECT Sno， COUNT（*） FROM SC GROUP BY Sno B: BSELECT Sno FROM SC GROUP BY Sno WHERE COUNT（*）> 3 C: CSELECT Sno FROM SC GROUP BY Sno HAVING COUNT（*）> 3 D: DSELECT Sno FROM SC GROUP BY Sno

下列查询语句中，错误的是（）。 A: SELECT Sno， COUNT（*） FROM SC GROUP BY Sno B: SELECT Sno FROM SC GROUP BY Sno WHERE COUNT（*）> 3 C: SELECT Sno FROM SC GROUP BY Sno HAVING COUNT（*）> 3 D: SELECT Sno FROM SC GROUP BY Sno

下列SQL语句中，正确的是（ ）。 A: SELECT S B: , SNAME FROM SC GROUP BY S C: SELECT S D: FROM SC GROUP BY S E: HAVING COUNT(*)>3 F: SELECT S G: ,Cname FROM SC GROUP BY S H: WHERE COUNT(*)>3 I: SELECT S J: FROM SC WHERE COUNT(*)>3 GROUP BY S

若要求“查询选修了3门以上课程的学生的学号”,正确的SQL语句是( ) A: SELECT sNo FROM SC GROUP BY sNo WHERE COUNT(*)> 3 B: SELECT sNo FROM SC GROUP BY sNo HAVING COUNT(*)> 3 C: SELECT sNo FROM SC ORDER BY sNo WHERE COUNT(*)> 3 D: SELECT sNo FROM SC ORDER BY sNo HAVING COUNT(*)> 3

下列SQL语句中，正确的是（ ）。 A: SELECT S B: , SNAME FROM SC GROUP BY S C: D: SELECT S E: FROM SC GROUP BY S F: HAVING COUNT(*)>3 G: SELECT S H: ,Cname FROM SC GROUP BY S I: WHERE COUNT(*)>3 J: SELECT S K: FROM SC WHERE COUNT(*)>3 GROUP BY S L:

在学生选课表SC中，查询选修了3号课程的学生的学号(XH)及其成绩(CJ)。查询结果按分数的降序排列。实现该功能的正确SQL语句是( )。 A: SELECT XH, CJFROM SC WHERE CH=′3′ORDER BY CJDESC B: SELECT XH, CJ FROM SC WHERE CH=′3′ORDER BY CJ ASC C: SELECT XH, CJ FROM SC WHERE CH=′3′GROUP BY CJ DESC D: SELECT XH, CJFROM SC WHERE CH=′3′GROUP BY CJ ASC

在学生选课表SC中，查询选修了3号课程的学生的学号(XH)及其成绩(GD)。查询结果按分数的降序排列。实现该功能的正确SQL语句是( )。 A: SELECT XH，GD FROM SC WHERE CH='3'ORDER BY GD DESC B: SELECT XH，GD FROM SC WHERE CH='3'ORDER BY GD ASC C: SELECT XH，GD FROM SC WHERE CH='3'GROUP BY GD DESC D: SELECT XH，GD FROM SC WHERE CH='3' GROUP BY GD ASC