现有订单表 orders ,包含用户信息 userid 、产品信息 productid ,下列()能返回至少被订购过两次的 productid
A.
select productid from orders wherecount(productid)>1
B.
select productid from orders where max(productid)>1
C.
select productid from orders where havingcount(productid)>1 group by productid
D.
select productid from orders group by productid having count(productid)>1