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