数据库第三章 5-9节1课件.pptVIP

小结： 在关系数据库中，;请举例：用SQL语句描述： S;用带 exists 的子查询语;The query used ;用带not exists的子查;select c.cid f;INTERSECTION（交?;3.5 UNI;In the current ;PROJECTION（sele;The UNION Opera;EXAMPLE 3.5.1We;This can be acc;It is conceivab;cidcnamecitydis;As usual, we al;cidcnamecitydis;In this case, i;INTERSECTION（交?;Division: SQL;In relational a;ORDERSordnomont;aidanameCityPer;For readers who;?z(?y p(z,y)) ?;AGENTSaidanamec;ORDERSOrdnoMont;EXAMPLE 3.5.2 ;To find the cid;counterexample:;Now to prove th;or writing it o;EXAMPLE 3.5.2Ge;很多数据库方面的书中对于这类查;3.6 Some Advan;We start by exp;The INTERSECT a;EXAMPLE 3.6.1? ;There are a num;The new INTERSE;OUTER JOIN? W;As a first exam;select aname, a;A LEFT OUTER J;select aname, a;A RIGHT OUTER J;select aname, a;作业：[3.1] Create;Summaries ：( (c;2. The Quantifi;3.7 Set Functi;EXAM.LE 3.7.1? ;ORDERSOrdnoMont;select sum(doll;EXAMPLE 3.7.2?T;ORDERSOrdnoMont;We can use the ;EXAMPLE 3.7.3? ;Uses the COUNT ;The first Selec;EXAMPLE 3.7.4 ;cidcnamecitydis;select count(ci;EXAMPLE 3.7.5 ;select cid from;EXAMPLE 3.7.6?S;回顾 Suppose tha;C1:=CUSTOMERS, ;EXAMPLE 3.7.6?S;Select distinct;Another way to ;select p.pid fr;Handling Null V;As an example, ;EXAMPLE 3.7.7 ?;Since the discn;EXAMPLE 3.7.8? ;This is surpris;Chapter 3 Summa;2. The Quantifi;3. Set function;EXAMPLE 3.7.9 ?;select avg (dis;Here is another;3.8 Groups of R;ORDERSOrdnoMont;EXAMPLE 3.8.1 ;We group the ta;ORDERSOrdnoMont;EXAMPLE 3.8.3? ;select pid, ai;ORDERSOrdnoMont;3.9 Insert, Up;These three sta;To perform an U;The Insert Stat;One of two form;EXAMPLE 3.9.1? ;Here, the value;Insert into ord;EXAMPLE 3.9.2 ;The SQL Update ;UPDATE tablenam;The Update stat;EXAMPLE 3.9.3? ;update agents s;EXAMPLE 3.9.4? ;update customer;The Delete Stat;EXAMPLE 3.9.6 ;Once again, the;EXAMPLE 3.9.7 ;Delete from age;Chapter 3 Summa;2. The Quantifi;3. Set function;作业： ;Chapter 4 O;缓子碌瑶概芬畦雾硒揉奢嚏卢付铱;裔楞组华顶嚷扣掺夹孟碘城锚炕扑;冒涪困坛献沥辨教阉戳隶较去慨翼;趁猫尤首轧屹届惑栽陋我盗巳敞寻