查询选修了A003课程且成绩在70分以上的学生,最准确的SQL语句是(
)。
A: SELECT
* FROM score WHERE c_no='A003' OR report>70
B: SELECT
* FROM score WHERE c_no='A003' AND report>70
C: SELECT
* FROM score WHERE c_no='A003'
D: SELECT
* FROM score WHERE report>70
)。
A: SELECT
* FROM score WHERE c_no='A003' OR report>70
B: SELECT
* FROM score WHERE c_no='A003' AND report>70
C: SELECT
* FROM score WHERE c_no='A003'
D: SELECT
* FROM score WHERE report>70
举一反三
- 查询选课关系SC(Sno,Cno,Score)表中还没有给定成绩()的课程号()和学号(),下列语句正确的是。() A: SELECT<br/>Sno,Cno<br/>FROM SC WHERE Score IS NULL B: SELECT*<br/>FROM SC WHERE Score =NULL C: SELECT<br/>Sno,Cno<br/>FROM SC D: SELECT<br/>Score FROM SC WHERE Sno,Cno<br/>IS NOT NULL
- 要从SC表中查找缺成绩（SCORE）的学生学号（NO），相应的SQL语句是（ ）。 A: SELECT NO FROM SC WHERE SCORE = 0 B: SELECT NO FROM SC WHERE SCORE IS 'NULL' C: SELECT NO FROM SC WHERE SCORE = NULL D: SELECT NO FROM SC WHERE SCORE IS NULL
- 查找成绩在70到80分之间的学生选课及得分情况。正确的SQL语句是（ ）。 A: SELECT * FROM 选课 WHERE 成绩>=70 AND 成绩<=80 B: SELECT * FROM 选课 WHERE 成绩≥70 AND 成绩≤80 C: SELECT * FROM 选课 WHERE 成绩>='70’ OR 成绩<='80’ D: SELECT * FROM 选课 WHERE 成绩>=70 OR 成绩<=80
- 下列的查询语句哪一项是错误的（选一项） A: Select * from stumarks where score>=60 B: Select * from (select * from stumarks where score>=60) C: Select * from (select * from stumarks where score>=60) as temp D: Select * from (select * from stumarks ) as temp where score>=60
- 成绩表 SCInfo(StId,CNo,Score) 的属性StId表示学号，CNo为课程编号，Score为成绩。从SCInfo表中找出无成绩的元组的SQL语句是（ ）。 A: SELECT * FROM SCInfo WHERE Score=NULL B: SELECT * FROM SCInfo WHERE Score IS '' C: SELECT * FROM SCInfo WHERE Score ='' D: SELECT * FROM SCInfo WHERE Score IS NULL