题目内容

查询曾经考过100分的学生的学号，可以使用的SQL语句是：（）

A. SELECT ALL Sno FROM SC WHERE Grade = 100;
B. SELECT DISTINCT Sno FROM SC WHERE Grade = 100;
C. SELECT ALL Sno FROM Student WHERE SC.Grade = 100;
D. SELECT DISTINCT Sno FROM Student WHERE SC.Grade = 100;

查看答案

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

更多问题

查询所有非计算机系学生的信息，不正确的SQL语句是：（）

A. SELECT * FROM Student WHERE Sdept != 'CS';
B. SELECT * FROM Student WHERE NOT Sdept = 'CS';
C. SELECT * FROM Student WHERE NOT Sdept IN ('CS');
D. SELECT * FROM Student WHERE Sdept IN ('MA', 'IS');

查看答案

选择题：查询所有名字中包含“数”字的课程信息，可以使用的SQL语句是：

A. SELECT * FROM Course WHERE Cname = '*数*';
B. SELECT * FROM Course WHERE Cname LIKE '*数*';
C. SELECT * FROM Course WHERE Cname LIKE '_数_';
D. SELECT * FROM Course WHERE Cname LIKE '%数%';

查看答案