数据库第三章所有例题参考题答案

《数据库第三章所有例题参考题答案》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、word格式11级信管，保密，图档上机考试题目与参考答案3.3SimpleSelectStatements1.EXAMPLE3.3.1findtheaidvaluesandnamesofagentsthatarebasedinNewYork.selectaid,anamefromagentswherecity=’NewYork’;2.EXAMPLE3.3.3Retrieveallpidvaluesofpartsforwhichordersareplaced.selectdistinctpidfromorde

2、rs;3.EXAMPLE3.3.4retrieveallcustomer-agentnamepairs,(cname,aname),wherethecustomerplacesanorderthroughtheagent.selectdistinctcustomers.cname,agents.anamefromcustomers,orders,agentswherecustomers.cid=orders.cidandorders.aid=agents.aid;4.EXAMPLE3.3.6allpairs

3、ofcustomersbasedinthesamecity.selectc1.cid,c2.cidfromcustomersc1,customersc2....word格式wherec1.city=c2.cityandc1.cid

4、.pidandx1.cid

5、nDuluthorDallas.selectdistinctcidfromorderswhereaidin(selectaidfromagentswherecity=‘Duluth’orcity=‘Dallas’)4.EXAMPLE3.4.2toretrieveallinformationconcerningagentsbasedin....word格式DuluthorDallas(veryclosetotheSubqueryinthepreviousexample).select*fromagentswh

6、erecityin(‘Duluth’,‘Dallas’);orselect*fromagentswherecity=‘Duluth’orcity=‘Dallas’;1.EXAMPLE3.4.3todeterminethenamesanddiscountsofallcustomerswhoplaceordersthroughagentsinDuluthorDallas.selectdistinctcname,discntfromcustomerswherecidin(selectcidfromorderswh

7、ereaidin(selectaidfromagentswherecityin(‘Duluth’,‘Dallas’)));2.EXAMPLE3.4.4tofindthenamesofcustomerswhoorderproductp05.selectdistinctcnamefromcustomers,orderswherecustomers.cid=orders.cidandorders.pid=‘p05’orselectdistinctcnamefromcustomerswhere‘p05’in(sel

8、ectpidfromorderswherecid=customers.cid);3.EXAMPLE3.4.5Getthenamesofcustomerswhoorderproductp07fromagent....word格式a03.selectdistinctcnamefromcustomerswherecidin(selectcidfromorderswherepid=‘p07’andaid=‘a03’)1.