在查询学生信息表Student_info数据时,为学号列Sid定义别名为学号,以下选项正确的是______。A.()select()Sid()as()学号()from()Student_info()B.()select()学号()Sid()from()Student_info()C.()select()学号()as()Sid()from()Student_info()D.()select()Sid=学号()from()Student_info
举一反三
- 按照学号进行分组，统计学生的平均成绩（） A: select sid, avg(grade) from student group by cid B: select sid, avg(grade) from student group by sid C: select sid, avg(grade) from sc group by sid D: select sid, avg(grade) from sc group by cid
- 查询学生的学号，姓名，选修课程号和课程成绩 A: select sid,sname,cid,grade from student,sc where student.sid=sc.sid B: select * from student,sc where student.sid=sc.sid C: select sid,sname,cid,cname from student,course D: select sid,sname,cid,cname from student,sc
- 在学生关系student(sid,sname……)中,student的属性分别表示学号和姓名,若要查询学号为19170201的学生姓名,下列SQL语句正确的是( )。Ⅰ.SELECT sname FROM student WHERE sid LIKE '19170201'Ⅱ.SELECT sname FROM student WHERE sid LIKE= '19170201'Ⅲ.SELECT sname FROM student WHERE sid='19170201' A: Ⅰ、Ⅱ B: Ⅰ、Ⅲ C: Ⅱ、Ⅲ D: Ⅰ、Ⅱ、Ⅲ
- 按照学号进行分组，统计学生的平均成绩，且平均分按降序排列 A: select sid, avg(grade) from sc group by sid order by avg(grade) desc B: select sid, avg(grade) from sc group by cid order by avg(grade) desc C: select sid, avg(grade) from student group by sid order by avg(grade) desc D: select sid, avg(grade) from student group by cid order by avg(grade)
- 查询STUDENT表中成绩大于90分的学号，正确的命令是 A: SELECT 学号 WHERE 成绩>90 B: SELECT 学号 FROM STUDENT SET 成绩>90 C: SELECT 学号 FROM STUDENT WHERE 成绩>90 D: SELECT 学号 FROM STUDENT FOR 成绩>90