> > >

MySQL MCQs

Which of the following represents a valid use of COUNT() in a WHERE clause?

select gid from `gd` group by gid having count(*) > 10 order by lastupdated desc

select gid from `gd` group by gid count(*) > 10 order by lastupdated desc

select gid from `gd` group by gid count() > 10 order by lastupdated desc

COUNT() cannot be used in a WHERE clause.

Answer

Correct Answer: select gid from `gd` group by gid having count(*) > 10 order by lastupdated desc

Explanation:

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

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it