题目内容

检索选修了课程”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;

查看答案

Do not wear（）in inflammable and explosive places

A. Cloth shoes
B. Rubber shoes
C. Spiked shoes
D. Sneakers

查看答案

which is bad habit for use of laboratory refrigerator（）

A. Regular defrosting and cleaning
B. Disinfect the inner surface regularly
C. All chemicals stored shall be marked with the name , the date and the storer
D. The flammable solution placed in the ordinary refrigerator shall be noted on the door of refrigerator

查看答案