達(dá)內(nèi)thinkjava編程思想按照要求編寫SQL語句當(dāng)天的知識(shí)點(diǎn)

PAGEPAGE11SQL按照要求編寫SQL語句（當(dāng)天的知識(shí)點(diǎn)2按照要求編寫SQL語句（綜合全部課程的知識(shí)點(diǎn)創(chuàng)建一個(gè)視圖v_emp，deptno,total_sal,查詢視圖v_emp刪除視圖表CLASSES和表SCHEDULE結(jié)構(gòu)如下:IDCLASS_NAMEVARCHAR2(20)TEACHER_IDNUMBER(9)CLASS_TIMEDATECLASS_IDNUMBER(9)CREATEVIEWclass_scheduleSELECTC.class_nameas“Name”,s.class_timeFROMclassescjoinschedulesonC.id=s.class_id語句創(chuàng)建視圖CLASS_SCHEDULE語法錯(cuò)誤，因?yàn)橐晥D丌可包含ORDERBY子句.NOTFOREIGNPRIMARY下面丌是SQLALTERTABLEADDSELECT*FROMProvince省省5815sql帳戶幾個(gè)月租通話短訊漫游數(shù)211510000selectaccount,count(userlist.ephone),sum(rent),nvl(sum(fee01),0),fromuserlistLEFTOUTERJOINchargeoncharge.ephone=userlist.ephonegroupbyaccount;PAGEPAGE5Createsequencestartwith1000incrementbySelectdeptno,sum(sal)total_sal,count(*)total_countFromempgroupbydeptno;Select*fromDropview表CLASSES和表SCHEDULE結(jié)構(gòu)如下:IDCLASS_NAMEVARCHAR2(20)TEACHER_IDNUMBER(9)CLASS_TIMEDATECLASS_IDNUMBER(9)CREATEVIEWclass_scheduleSELECTC.class_nameas“Name”,s.class_timeFROMclassescjoinschedulesonC.id=s.class_id語句創(chuàng)建視圖CLASS_SCHEDULE“NameORDERBY子句.NOTFOREIGNPRIMARYALTERTABLEADDSELECT*FROM視圖可以掉對(duì)部分原始數(shù)據(jù)答Selctc.citynoc.cityname,c.stateno,nvl(s.statename,‘直轄市’statenameFromcitycleftouterjoinstatesPAGEPAGE8Onc.stateno=Select*fromstudentWherenamenotin(selectdistinctnamefromstudentwherescore<selectaccount,count(userlist.ephone),sum(rent),nvl(sum(fee01),0),fromuserlistLEFTOUTERJOINchargeoncharge.ephone=userlist.ephonegroupbyaccount;SELECTename,sal,ROWNUM (SELECTename,salFROMempWHEREROWNUM<=S