题目:查询选修了a001号课程的学生的最高成绩()
A、select cid, max(grade) from course where cid=’a001’ group by cid
B、select cid,max(grade) from student where cid=’a001’ group by cid
C、select cid, max(g……继续阅读 »
题目:查询成绩在60分以上的学生的信息及其选课的课程号和成绩
select * from student,course where grade>=60
select student.*,cid,grade from student,sc where student.sid=sc.sid and grade>=60
select * from student,……继续阅读 »
题目:查询姓“李”的学生的所有信息
select * from student where sname like ‘%李%
select * from student where sname like “%李%”
select * from student where sname like ‘#李%’
select * from student where ……继续阅读 »
题目:按照课程号进行分组,统计学生平均成绩大于60分的学生的信息( )
select cid,avg(grade) from student where avg(grade)>60 group by cid
select cid,avg(grade) from student group by cid having avg(grade)>60
select……继续阅读 »
题目:统计信息技术系学生总人数,所使用的语法命令为()
select *from student
select count(*) from student
select count(*) from student where depart=’信息技术系’
select count(*) from student where depart is’信息技术系’
……继续阅读 »
题目:查询成绩不为空值的学生的信息,语法命令为()
select * from sc where grade is not null
select * from sc where grade!=null
select * from sc where grade is not ‘’
select * from sc where grade!=’’
喵查答案:[……继续阅读 »
题目:查询不在信息技术系,机电工程系和管理系的学生的信息,所使用的语法命令为( )
select * from student where not depart=’ 信息技术系’ and depart=’ 机电工程系’ and depart=’ 管理系’
select * from student where depart not in(’信息技术系’,’机……继续阅读 »