student表设计如下,查询所有‘男‘同学的信息正确SQL语句是()。
A. select sname from student where sex=’ 男’
B. select * from student where sex=’ 男’
C. select all from student where sex=’ 男’
D. select * from student where sex=男
查看答案
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