有一产品追踪表,里面有几千条数据,记录产品进入出去情况。其中有部份产品多次进出,都记录在这个追踪表(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查找
表结构如下:
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查找
select proname from trace
where proid = '出'
group by proname
having count(proname)>3
group by...having count(*)>=3