數(shù)據(jù)庫原理及應(yīng)用——崔巍書后上機(jī)實(shí)驗(yàn)-文庫吧資料
2024-08-03 11:17本頁面
【正文】 客戶 c,訂購單 owhere =and 訂購日期 is null24select 客戶名稱,聯(lián)系人,電話,訂單號(hào),訂購日期from 客戶,訂購單where =and 訂購日期39。19select COUNT(distinct 訂單號(hào))as 訂購單個(gè)數(shù),AVG(數(shù)量*單價(jià))as 平均金額from 產(chǎn)品,訂單名細(xì)where =20select 訂單號(hào),COUNT(訂單號(hào)) 項(xiàng)目數(shù),SUM(*) 總金額from 產(chǎn)品 g,訂單名細(xì) owhere =group by 訂單號(hào)21select ,MAX(數(shù)量*單價(jià)) 最高金額,MIN(數(shù)量*單價(jià)) 最低金額from 訂購單 o,產(chǎn)品 g,訂單名細(xì) iwhere =and =and 產(chǎn)品名稱=39。)18select SUM(數(shù)量*單價(jià)) 總金額from 產(chǎn)品,訂單名細(xì)where =and 產(chǎn)品名稱=39。14select * from 產(chǎn)品 order by 單價(jià)15select *from 產(chǎn)品order by 產(chǎn)品名稱,單價(jià)16select COUNT(產(chǎn)品號(hào))from 產(chǎn)品17select SUM(數(shù)量)from 訂單名細(xì)where 產(chǎn)品號(hào)=(select 產(chǎn)品號(hào)from 產(chǎn)品where 產(chǎn)品名稱=39。13select * from 客戶 where 客戶名稱 not like 39。)11select * from 產(chǎn)品 where 單價(jià) between 1000 and 500012select * from 客戶 where 客戶名稱 like 39。)9select * from 訂購單where 訂單號(hào) in(select 訂單號(hào)from 訂單名細(xì)where 數(shù)量10)10select * from 產(chǎn)品 where 單價(jià) =(select 單價(jià) from 產(chǎn)品 where 規(guī)格說明=39。and =and =and =8select * from 訂單名細(xì)where 產(chǎn)品號(hào) in(select 產(chǎn)品號(hào)from 產(chǎn)品where 產(chǎn)品名稱=39。7select distinct 客戶名稱,聯(lián)系人,電話from 客戶 c,產(chǎn)品 g,訂購單 o,訂單名細(xì) dwhere 產(chǎn)品名稱=39。201112139。2011103039。ipad39。Macbook39。Macbook39。二、實(shí)驗(yàn)內(nèi)容：用SQL SELECT語句完成各種數(shù)據(jù)查詢。4使客戶號(hào)為C002的訂購單的訂購數(shù)量增加10.5刪掉客戶號(hào)為C002的訂單名細(xì)記錄。第二個(gè)更新根據(jù)參照完整性約束，訂購單表參照客戶表，而客戶表中沒有客戶號(hào)為“C011”的客戶。刪除訂購單號(hào)為“or01”的記錄時(shí)無法刪除，因?yàn)橛唵蚊?xì)表參照訂購單表。C00239。and訂購單wherefromC00239。and訂購單whereset受用戶定義完整性約束4update939。數(shù)量=0 訂單名細(xì)or0739。whereC00939。set受參照完整性約束update訂單號(hào)=39?？蛻籼?hào)=39。訂購單C00139。whereset受參照完整性約束3update訂單號(hào)=39。from訂購單客戶號(hào)=39。客戶)2delete,39。,39。values(39。into639。GD00239。339。or0139。訂單名細(xì) )insert,39。,39。,39。values(39。into439。GD00139。139。or0139。訂單名細(xì) insertor1939。訂購單(訂單號(hào)))insert,39。values(39。intoor0139。C00139。訂購單(客戶號(hào),訂單號(hào))insertMac Pro39。GD01039。產(chǎn)品(產(chǎn)品號(hào),產(chǎn)品名稱))insert,39。,39。,39。values(39。into50003
外語相關(guān)推薦
鄂ICP備17016276號(hào)-1