course表设计如下,查询所有的课程信息正确SQL语句是()
A. select * from course
B. select * from course ;
C. select all from course
D. select distinct from course
查看答案
course表设计如下,查询‘数据结构‘课程的所有信息的正确SQL语句是()
A. select * from course where cname=’ 数据结构’
B. select * from scourse where cname=’ 数据结构’ ;
C. select * from course where cno= 数据结构
D. select all from course where cname=’ 数据结构’ ;
student表设计如下,查询1994后出生的学生信息的正确SQL语句是()
A. select* from student where birth>’1994’;
B. select * from student where year( birth)>’1994’;
C. select * from student where year(birth,yy)>=’1994’;
D. select birth from studen where birth>’1994’;
scores表设计如下,查询每个学生的平均成绩的正确SQL语句是()
A. select avg(Score) as average from scores;
B. select Score as average from scores;
C. select cno , avg(Score) as average from scores group by sno
D. select sno , avg(Score) as average from scores group by sno
scores表设计如下,查询每门课程的平均成绩的正确SQL语句是()
A. select avg(Score) as average from scores;
B. select cno , Score as average from scores;
C. select cno , avg(Score) as average from scores group by cno
D. select Score as average from scores;