数据库Oracle第3课时1.pptVIP

例4：找出在同一城市居住的顾客对。 写SQL Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 例4：找出在同一城市居住的顾客对。 SELECT c1.cid, c2.cid FROM customers c1, customers c2 WHERE c1.city = c2.city; 为了不重复列出， 另外自身配对不列出，可以 WHERE c1.city = c2.city AND c1.cid c2.cid; Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 例5：找出比Smith工资高的代理商。 SELECT a2.aname FROM agents a1, agents a2 WHERE a1.aname = ‘Smith’ AND a2.salary a1.salary; 例6：写出购买过商品的顾客姓名和产品名称。（多表连接） SELECT c.cname, p.pname FROM customers c, products p, orders o WHERE o.cid = c.cid AND o.pid = p.pid; 一般来说，N个表连接需要N-1个连接条件。 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 例7：写出购买过单价超过1元的产品的顾客名单。（多表连接） SELECT c.cname FROM orders o, customers c, products p WHERE o.cid = c.cid AND o.pid = p.pid AND p.price 1; Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 例8：找出与经理在同一城市的代理商。 写SQL Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 例8：找出与经理在同一城市的代理商。 SELECT a2.aname FROM agents a1, agents a2, locations l1, locations l2 WHERE a1.manager = a2.aid AND a1.lid = l1.lid AND a2.lid = l2.lid AND l1.c