有订单表order,包含用户信息uid,商品信息gid,以下()语句能够返回至少被购买两次的商品id。
A: SELECTgidFROMorderWHERECOUNT(gid)>1;
B: SELECTgidFROMorderWHEREMAX(gid)>1;
C: SELECTgidFROMorderGROUPBYgidHAVINGCOUNT(gid)>1;
D: SELECTgidFROMorderWHEREHAVINGCOUNT(gid)>1GROUPBYgid;
A: SELECTgidFROMorderWHERECOUNT(gid)>1;
B: SELECTgidFROMorderWHEREMAX(gid)>1;
C: SELECTgidFROMorderGROUPBYgidHAVINGCOUNT(gid)>1;
D: SELECTgidFROMorderWHEREHAVINGCOUNT(gid)>1GROUPBYgid;