consider the following table structure of students rollno number 4 name..., ANSI SQL, Databases

Test
- Model Test
Index

Question:Consider the following table structure of students:
        rollno        number(4) 
        name          varchar(20) 
        course        varchar(20) 
What will be the query to display the courses in which the number of students 
enrolled is more than 5?

A Select course from students where count(course) > 5; 
B Select course from students where count(*) > 5 group by course; 
C Select course from students group by course; 
D Select course from students group by course having count(*) > 5; 
E Select course from students group by course where count(*) > 5; 
F Select course from students where count(group(course)) > 5; 
G Select count(course) > 5 from students; 
H None of the above

/30

+ AnswerD

+ Report

Descriptive on ANSI SQL Ebook

Total Preview: 1321

Question:Consider the following table structure of students: rollno number(4) name varchar(20) course varchar(20) What will be the query to display the courses in which the number of students enrolled is more than 5?

A Select course from students where count(course) > 5;

B Select course from students where count(*) > 5 group by course;

C Select course from students group by course;

D Select course from students group by course having count(*) > 5;

E Select course from students group by course where count(*) > 5;

F Select course from students where count(group(course)) > 5;

G Select count(course) > 5 from students;

H None of the above

D