还剩1页未读,继续阅读
文本内容:
【实验
2.1】字段查询1SELECT*fromcategoryWHEREName=,言风玻璃,;SELECT*fromordersWHEREOid=l;【实验
2.21多条件查询select*FROMautopartsWHEREis_sale=rrTnANDPrice1000;|【实验
2.3】DISTINCTselectDISTINCT]Client_cidFROMcoirir.ent;WHEREComment_id=l;【实验
2.4】ORDERBYSELECT*FROMautopartsWHZREApnameinSELECTNameFROMcategoryWHEREid=1ORDERBYApidDESC;select*frorriclientwhereYEARCreatetiir.e=YEARNOW;【实验
2.5】GROUPBYSELECTSUMtotal_priceFROMorderaGROUPBYClient_cid;SELECTCOUNTNumberFROMorder_has_autopartsGROUPBYdeal_price;【实验
2.6】COUNTOSELECTCOUNT|sNameFROMcategory;SELECTCOUITTOicjFROMorderaGROUPBYorder_date;【实验
2.7[SUM1SELECTSUMtotal_priceFROMorderaGROUPBYorder_date;|【实验
2.8[AVGSELECTAVGtotal_priceFROMordera;|【实验
2.9】MAXSELECTMAXNumberFROMorder_has_autoparts;SELECTMAXCnameiFROMclient|;【实验
2.10]MINSELECTMINPriceFROMautoparts|;【实验
2.11】内连接查询SELECTCnanteFROMclientI2-R-TERJOINordersONclient.cld=ordera.Cllent_cld|;SELECTNameFROMcategoryINITERJOINShoppingCartONcategory.Category_ID=ShoppingCart.Aucoparts_apid;|【实验
2.12】外连接查询SELECTcidCoirmentsFROMclientLEFTJOINcornir.entONIcoirment.Cllent_cid=client.cid;SELECTcidCoirmentsFROMclientRIGHi|JOINcoimc.entONcoirment.Client_cid=client.cid;【实验
2.13】复合条件连接查询SELECTordera.*fCnameFROMorderafclientWHEREcid=_;|selectPriceFROMautopartsWHEREautoparts.Apid=shoppingcart.Autoparts_apidORDERBYPrice];【实验
2.141INSELECTClienc_cidFROMorderaWHEREOldinSELECTOrder_oidFROMorder_has_autopartsWHEREAutoparts_apid=_|;SELECTClient_cidFROMorderaWHEREOldnot|inSELECTOrder_oidFROMorder_has_autoparrsWHEREAuroparrs_apid=_;【实验
2.15】比较运算符SELECT*FROMorderaWHEREClient_cidmSELECTcidFROMclientWHEREYEARCreatetime=YEARNOWandtocal_price100^【实验
2.16]EXISTSselect*fromclientwhereEXISTSSELECTcidFROMclientWHEREcid=100;|select*fromautopartswhereEXISTSSELECTApidFROMautopartsWHEREApid=100ANDPrice5;|【实验
2.17】ANYselectApidfroir.autopaxtswnerePriceA1JYSELECTtotal_priceFROMordera;【实验
2.18】ALLselectApidfromautopartswherePriceALLSELECTtotal_priceFROMordera;【实验
2.191集合查询SELECT*FROMautopartsWHEREPrice5UNIONSELECT*fromaucopartsWHEREApid=1ORApid=2;SELECT♦FROMautoparrsWHEREPrice5UNIONALLSELECT*fromautopartsWHEREMid=1ORApid=2;。