语句 SELECT MAX(Score) FROM SCInfo 查询结果的记录数有（）

2021-04-14

答案：

1

0
查询选修课程号为“9710011”的课程的学生学号，成绩。select stid, score from scinfo where cno=_______________
1
下列的查询语句哪一项是错误的（选一项） 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
2
查询选修课程好为'971001'的课程的学生学号和成绩：select stid,score from scinfo where cno=_____________
3
查询scott用户的emp表中的总记录数,可以使用下列哪个语句?() A: SELECT MAX(empno) FROM scott.emp; B: SELECT<br/>COUNT(empno) FROM scott.emp; C: SELECT COUNT(comm) FROM scott.emp; D: SELECT COUNT(*) FROM scott.emp;
4
查询book表中price字段的最大值，查询语句是： A: select max(price) from book； B: select min(price) from book； C: select price from min book； D: select price from max book；

语句 SELECT MAX(Score) FROM SCInfo 查询结果的记录数有（ ）