现有订单表orders，包含用户信息userid, 产品信息 productid,

select productid from orders where count(productid)>1

select productid from orders where max(productid)>1

select productid from orders where having count(productid)>1 group by productid_

select productid from orders group by productid having count(productid)>1