在MySQL中,以下哪项是在WHERE子句中有效使用COUNT()?( )
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()不能在WHERE子句中使用.