內(nèi)容文本sql語言

1、5aaindexon tagtotalon togbcjfields usebrowfields 班級,9-select * from xsda wherenot and sele xsda. 學(xué)號5aaindexon tagtotalon togbcjfields usebrowfields 班級,9-select * from xsda wherenot and sele xsda. 學(xué)號,bjml. 班級名稱,xsda. xsda,bjml,xscj where xsda.學(xué)號= xscj.學(xué)號語=80 and xscj.高等數(shù)學(xué)=809-xsgl!bjmlINNERJOINxsgl!x

2、sda; INNER JOIN xsgl!xscj ;Xsda.Xscj.=男orderby ,xscj. 高等數(shù)學(xué),xscj. 外語 and xsda.班級=bjml.班級having xscj., WHEREXscj.80; AND Xscj.外語 = 809-jml.班級名稱, avg(xscj.高等數(shù)學(xué)) 高數(shù)平均分,max(xscj.高等數(shù)學(xué)xsda,bjml,xscj where bjml.as =xsda.分,min(xscj.高等數(shù)學(xué)) as 高數(shù)最低分 from and xsda.學(xué)號=xscj.學(xué)號 group by bjml.班級 xsgl!xsdaINNERJOININ

3、NERJOINxsgl!bjmlXsda.Xsda.Xscj.學(xué)號WHEREXscj.selectavg(xscj.外語fromxscj); ORDER BY Xscj.外語9-SELECTXsda.班級,bjml班級名稱AVG(Xscj.平均分AS 班平均分INNERJOINxsgl!bjmlXsda.Xsda.Xscj.學(xué)號; GROUP BY Xsda.班級; HAVING 班平均分=80INNERJOINxsgl!bjmlXsda.Xsda.Xscj.學(xué)號; GROUP BY Xsda.班級; HAVING 班平均分=8010-crea tabl xxcj(學(xué)號c(8), 課c(3),i(4),選修學(xué)期c(1),錄日期10-altertablexxcjadd 說明10-o xxcj(學(xué)號, 課,成績,選修學(xué)期,成績登錄日期) (20050090,011,69,3,2011-04-sele*fromotable10-Altertablexxcjalter 成績update xxcj set 成績=iif(val(成績)=60,及格,不及格10-delefromxxcjwhere 成績=不及格10-droptable11-settalkaccept 請輸入數(shù)據(jù)庫名： to opendataaccept 請輸入數(shù)據(jù)庫名： to opend