题目内容

在学生选课数据库中，查询平均成绩大于等于60分的同学，SQL语句为（）

A. SELECT Sno, AVG（Grade） FROM SC GROUP BY Sno HAVING AVG（Grade）＞=60;
B. SELECT Sno FROM SC WHERE Grade＞=60 GROUP BY Sno;
C. SELECT Sno, Grade FROM SC GROUP BY Sno HAVING AVG（Grade）＞=60;
D. SELECT Sno FROM SC GROUP BY Sno HAVING Grade ＞=60;

查看答案

搜索结果不匹配？点我反馈

更多问题

下列选项中哪一个是正确的空值查询条件的SQL表达（）

A. ＜＞NULL
B. !=NULL
C. IS NOT NULL
D. NOT IS NULL

查看答案

检索选修了课程”C1”的学生中成绩最高的学生的学号，正确的SELECT语句为（）

A. SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE ＞=ALL （SELECT Grade FROM SC WHERE Cno=’C1’）
B. SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE IN （SELECT Grade FROM SC WHERE Cno=’C1’）
C. SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE ＞ ANY （SELECT Grade FROM SC WHERE Cno=’C1’）
D. SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE ＞= （SELECT Grade FROM SC WHERE Cno=’C1’）

查看答案

After using reagents in chemical lab, you should to（）

A. put it back in place immediatel
B. put it in an easy accessing place
C. make up by yourself,when it is insufficient
D. keep the bottle open for easy use next time

查看答案

列出SC表中所有考试不及格的学生的学号Sno（无须重复），其SQL语句为（）

A. SELECT DISTINCT Sno FROM SC WHERE Grade＜60;
B. SELECT DISTINCT Sno FROM SC WHERE Grade IS NULL;
C. SELECT Sno FROM SC WHERE Grade＜60;
D. SELECT ALL Sno FROM SC WHERE Grade＜60;

查看答案

在学生选课数据库中，查询平均成绩大于等于60分的同学，SQL语句为（）

A. SELECT Sno, AVG（Grade） FROM SC GROUP BY Sno HAVING AVG（Grade）＞=60; B. SELECT Sno FROM SC WHERE Grade＞=60 GROUP BY Sno; C. SELECT Sno, Grade FROM SC GROUP BY Sno HAVING AVG（Grade）＞=60; D. SELECT Sno FROM SC GROUP BY Sno HAVING Grade ＞=60;

下列选项中哪一个是正确的空值查询条件的SQL表达（）

检索选修了课程”C1”的学生中成绩最高的学生的学号，正确的SELECT语句为（）

After using reagents in chemical lab, you should to（）

列出SC表中所有考试不及格的学生的学号Sno（无须重复），其SQL语句为（）

A. SELECT Sno, AVG（Grade） FROM SC GROUP BY Sno HAVING AVG（Grade）＞=60;
B. SELECT Sno FROM SC WHERE Grade＞=60 GROUP BY Sno;
C. SELECT Sno, Grade FROM SC GROUP BY Sno HAVING AVG（Grade）＞=60;
D. SELECT Sno FROM SC GROUP BY Sno HAVING Grade ＞=60;