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