查询选课门数大于3门的同学学号，姓名, 选课门数Select ______________from student s, scwhere s.sno=sc.sno group by __________having _____________
A: sno, sname, count(*) ; sno, sname; count(*)>3
B: sno, sname, count(*) ; sno; count(*)>3
C: sno, sname, count(cno) ; sno; count(cno)>3
D: sno, sname, count(sno) ; sno; count(sno)>3
A: sno, sname, count(*) ; sno, sname; count(*)>3
B: sno, sname, count(*) ; sno; count(*)>3
C: sno, sname, count(cno) ; sno; count(cno)>3
D: sno, sname, count(sno) ; sno; count(sno)>3
举一反三
- 统计每门课程的选课人数select cno , _________from scgroup by ________ A: count(*) ; cno B: count(sno) ; cno C: count(*) ; sno D: count(sno) ; sno
- 以下（ ）语句可查询选修了三门以上成绩在80分以上课程的学生学号。 A: select sno from scwhere grade>80group by snohaving count(cno)>3 B: select sno from scwhere grade>80group by snohaving count(*)>3 C: select sno from scwhere grade>80 and count(*)>3group by sno D: select sno from scwhere grade>80group by snohaving count(sno)>3
- 针对学生选课表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;
- 下列查询语句中，错误的是（）。 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
- 若要求“查询选修了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