> > >

Hadoop MCQs

Consider the following table structure of students:
        rollno        int
        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?

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;

None of the above

Answer

Correct Answer:

Explanation:

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

Hadoop Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it