MCQs > IT & Programming > PostgreSQL >

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?


PostgreSQL MCQs

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?


Answer

Correct Answer:

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

Explanation:

Note: This Question is unanswered, help us to find answer for this one

PostgreSQL Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

PostgreSQL Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it