freepeople性欧美熟妇, 色戒完整版无删减158分钟hd, 无码精品国产vα在线观看DVD, 丰满少妇伦精品无码专区在线观看,艾栗栗与纹身男宾馆3p50分钟,国产AV片在线观看,黑人与美女高潮,18岁女RAPPERDISSSUBS,国产手机在机看影片

正文內(nèi)容

數(shù)據(jù)庫(kù)原理及應(yīng)用——崔巍書(shū)后上機(jī)實(shí)驗(yàn)-全文預(yù)覽

  

【正文】 產(chǎn)品號(hào) in(select 產(chǎn)品號(hào)from 產(chǎn)品where 產(chǎn)品名稱=39。11)、基于單個(gè)表按投影操作定義視圖create view v_cus asselect 客戶號(hào),客戶名稱from 客戶使用select * from v_cus2)、基于單個(gè)表按選擇操作定義視圖create view v_order asselect *from 訂購(gòu)單where 客戶號(hào)=39。25select *from 產(chǎn)品 outawhere 單價(jià)=(select MAX(單價(jià))from 產(chǎn)品 innerawhere =)26select 客戶號(hào)from 客戶where not exists(select *from 訂購(gòu)單where =)27select *from 客戶where exists(select *from 訂購(gòu)單where =)28select 產(chǎn)品名稱from 產(chǎn)品where 單價(jià)= any(select 單價(jià)/219select COUNT(distinct 訂單號(hào))as 訂購(gòu)單個(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 訂購(gòu)單 o,產(chǎn)品 g,訂單名細(xì) iwhere =and =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。)11select * from 產(chǎn)品 where 單價(jià) between 1000 and 500012select * from 客戶 where 客戶名稱 like 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。201112139。ipad39。Macbook39。第二個(gè)更新根據(jù)參照完整性約束,訂購(gòu)單表參照客戶表,而客戶表中沒(méi)有客戶號(hào)為“C011”的客戶。C00239。訂購(gòu)單whereC00239。訂購(gòu)單where受用戶定義完整性約束4update數(shù)量=0 whereset訂單號(hào)=39。客戶號(hào)=39。where受參照完整性約束3update訂單號(hào)=39??蛻?39。values(39。639。339。訂單名細(xì) ,39。,39。intoGD00139。or0139。insert訂購(gòu)單(訂單號(hào)),39。intoC00139。insertGD01039。)insert,39。values(39。500039。iphone39。產(chǎn)品J商場(chǎng)39??蛻?客戶號(hào),客戶名稱),39。,39。,39。into12345639。小明39。C00139。部分記錄insert訂單名細(xì)(訂單號(hào),序號(hào),數(shù)量 訂購(gòu)單(訂單號(hào)) index 創(chuàng)建表時(shí),primary keygdn_nui 客戶(客戶名稱)2create數(shù)量1000)建立索引1create add constraint null3alter (規(guī)格說(shuō)明)2alter 產(chǎn)品add columnconstraint check(數(shù)量0),primarykey(訂單號(hào),序號(hào)))產(chǎn)品,數(shù)量 null 訂購(gòu)單,
點(diǎn)擊復(fù)制文檔內(nèi)容
外語(yǔ)相關(guān)推薦
文庫(kù)吧 www.dybbs8.com
備案圖鄂ICP備17016276號(hào)-1