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

Test
- Model Test
Index

Question:Consider the following structure of the students table:
        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 student's group by course; 
D Select course from student's group by course having count(*) > 5;

/85

+ AnswerD

+ Report

Descriptive on PostgreSQL Ebook

Total Preview: 1580

Question:Consider the following structure of the students table: 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 student's group by course;

D Select course from student's group by course having count(*) > 5;

D