數(shù)據庫原理實驗報告-全文預覽
【正文】 說至關重要，否則后續(xù)的設計和實施都會有想象不到的麻煩。delete from Toys where cBrandId in (select cBrandIdfrom ToyBrandwhere cBrandName=39。select into PremiumToys from Toys,Wrapper,OrderDetail where 20 and = and =。（要求用子查詢實現(xiàn)）select vToyNamefrom toyswhere cToyId IN (select cToyId from OrderDetail where cWrapperId is null)（14）顯示已收貨定單的定單號碼以及下定單的時間。.39。select cOrderNo,mToyCostFrom Where mToyCost50。select top 5 cToyId,SUM(iTotalSold) as total from PickOfMonth where iYear=39。年份39。玩具ID39。select *From Where vToyName LIKE 39。select cOrderNo,cShopperId,mTotalCostfrom ORDER BY mTotalCost ASC。,39。（5）對表Toys實施下面數(shù)據完整性規(guī)則：（1）玩具的現(xiàn)有數(shù)量應在0到200之間；（2）玩具適宜的最低年齡缺
教學課件相關推薦
鄂ICP備17016276號-1