在MySQL中,请看下面的学生表结构:
rollno number(4)
name varchar(20)
course varchar(20)
要显示注册学生人数超过5人的课程,应如何查询?( )
select course from students where count(course) > 5;
select course from students where count(*) > 5 group by course;
select course from students group by course;
select course from students group by course having count(*) > 5;
select course from students group by course where count(*) > 5;
select course from students where count(group(course)) > 5;
select count(course) > 5 from students;
H. 都不对