摘要:
写SQL,学生表student(studentid,name)绩表score(scoreid,studentid,score)求出平均成绩大于60 且 至少有两门成绩高于70分的学生的编号和姓名/*学生表student(studentid,name)绩表score(scoreid,studentid,score)求出平均成绩大于60 且 至少有两门成绩高于70分的学生的编号和姓名*/select studentid, name from student where studentid in(select studentidfrom scorewhere studentid in (select 阅读全文
posted @ 2011-07-15 13:06
冬雨在路上
阅读(384)
评论(0)
推荐(1)
浙公网安备 33010602011771号