全文预览

数据库系统原理课程设计报告

上传者:火锅鸡 |  格式:doc  |  页数:12 |  大小:0KB

文档介绍
DE之计数РFROM (S INNER JOIN G ON S.SNO = G.SNO) INNER JOIN C ON O = OРGROUP BY AME, OРHAVING (((Count(G.GRADE))<10));Р查询结果:Р13)SQL语句:SELECT S.NAME, Count(G.GRADE) AS GRADE之计数РFROM S INNER JOIN G ON S.SNO=G.SNOРWHERE (((G.GRADE)<"60"))РGROUP BY S.NAMEРHAVING (((Count(G.GRADE))=4));Р查询结果:Р14)SQL语句:SELECT C.TNO, T.NAME, Sum(C.XF) AS XF之总计РFROM C INNER JOIN T ON C.TNO=T.TNOРGROUP BY C.TNO, T.NAME;Р查询结果:Р15)SQL语句:SELECT T.NAME, T.TNO, Count(O) O之计数РFROM T INNER JOIN C ON T.TNO = C.TNOРGROUP BY T.NAME, T.TNOРHAVING (((Count(O))>=3));Р查询结果:Р16)SQL语句:SELECT T.NAME, T.TNO, Count(O) O之计数РFROM T INNER JOIN C ON T.TNO=C.TNOРGROUP BY T.NAME, T.TNOРHAVING (((Count(O))=1));Р查询结果:Р17)SQL语句:РSELECT S.CLASSNO, O, Max(G.GRADE) AS GRADE之最大值РFROM S INNER JOIN G ON S.SNO = G.SNOРGROUP BY S.CLASSNO, O;Р查询结果:Р注:可另附页

收藏

分享

举报
下载此文档