數(shù)據(jù)庫技術(shù)與應用課后習題答案-閱讀頁
2024-08-25 01:51本頁面
【正文】 es 圖書(圖書號))實驗4 答案1． Select xh,xm,xbm from stu_info,gdept where = and =’信息科學與工程’或 Select xh,xm,xbm from stu_info where xsh=(select xsh from gdept where xsm=’信息科學與工程’)2． Select ,xm,km from stu_info,xk,gcourse where = and = and kscj85 3． Select xh,xm,xsm from stu_info,gdept where = and xh like ‘2000%’4． Select xh, xm from stu_info where xh in (select xh from xk where kch=’090101’ and kscj60)或 select ,xm from stu_info,xk where = and kch=’090101’ and kscj605. select ,xm,km from stu_info,xk,gcourse where = and = and xsh=’12’ and kscj606. select ,xm,xsm from stu_info,xk,gdept where = and = and kkny=’20011’ group by ,xm,xsm having count(*)=10實驗5 答案2題參考實驗4答案3. Select xh,xm,xbm,bh from stu_info where zyh in (select zyh from stu_info where xm=’李明’) order by xh實驗6答案1． Create view num_ban as select count(distinct bh) from stu_info2． Create view ban as select distinct bh from stu_info3． Create view is_stu as select xm,xbm,bh from stu_info where xsh=’01’ or xsh=’02’4． Create view zhang_stu as select * from stu_info where xsh=’01’ and xm like ‘張%’或 Create view zhang_stu as select * from stu_info,gdept where xsm=’材料科學與工程’ and xm like ‘張%’ and =8. Create view 材0168 as select stu_info.*,xk.* from stu_info,xk where bh=’材0168’ and =9. Create view gaoshu _stu as select xm from stu_info,xk,gcourse where = and = and km=’高等數(shù)學’或 Create view gaoshu _stu as select xm from stu_info where xh in(select xh from xk where kch =(select kch from gcourse where km=’高等數(shù)學’) )風輕云淡
環(huán)評公示相關推薦
鄂ICP備17016276號-1