select * from 库存表 a where (a.商品代号,a.储位,a.生产日期) in (select a.商品代号,a.储位,a.生产日期 from 库存表 group by 商品代号,储位,生产日期 having count(*) > 1) and id not in (select min(id) from 库存表 group by 商品代号,储位,生产日期 having count(*)>1)
执行会报错,不知错在哪?请高手指点!先谢了!!