数据库实验二报数据库实验二报告.docVIP

实验二 简单查询及子查询 一. 目的： 练习SQL. 二. 内容： 1. 练习查询语句:（Example3.4.1-3.4.3; Example3.4.6-3.4.14； Example3.5.1.-3.5.2). 操作内容截图如下： CUSTOMERS : AGENTS: PROODUCTS: ORDER; 2练习查询语句 Example3.4.4 select distinct cid from orders where aid in (select aid from agents where city=Duluth or city=Dallas); Example3.4.2 Retrieve all information concerning agents based in Duluth or Dallas. select * from agents where city in(Duluth,Dallas); Example3.4.3 select cname,discnt from customers where cid in(select cid from orders where aid in(select aid from agents