请Mysql高手们指点下，向你们致敬！

[fengyezhiiq]

有一产品追踪表，里面有几千条数据，记录产品进入出去情况。其中有部份产品多次进出，都记录在这个追踪表（trace）中。现想查询出在追踪表中凡出去过3次的产品详细数据。
表结构如下：
ID proname promany senddate proid
1 Toner 300 2010-03-15 1
2 LBP 500 2010-02-25 2
3 Toner 300 2010-01-20 1

....
试写下MYSQL查找

[fengyezhiiq]

这是我在网上看到的一个题，我不会写，想请教下各位大虾！
随便帮顶~SF

[永生天地]

select proname from trace group by proname having count(proname)>3

[永生天地]

[Quote=引用 2 楼 xys_777 的回复:]
SQL code
select proname from trace group by proname having count(proname)>3
[/Quote]

select proname from trace
where proid = '出'
group by proname 
having count(proname)>3

[dawugui]

select proname from trace group by proname having count(1) >= 3

[fengyezhiiq]

谢谢指点！

[fengyezhiiq]

怎么给分呀？

[ChinaJiaBing]

group by...having count(*)>=3