这种查询语句怎么写？？？？？？？？？？？？？？？

[czhp]

表(temp)中只有一个字段：id,且可重复。现要查出此字段重复次数为5的id.
"select id from temp where ?????? group by id"
请问WHERE条件怎么写？

[Wingsun]

select id from temp where ?????? group by id having count(id)=5

[zzssyyvc]

select distinct id from temp group by id having count(id)=5