所有的课程都不重复,你用distinct吗,用min吗?
select * from 表名 where 学分<(select 学分 from 表名 where 课程名='计算机网络')
查询select * from student where score between 50 and 60
改成绩
update student set score=score+5 where score between 50 and 60
欢迎分享,转载请注明来源:内存溢出
所有的课程都不重复,你用distinct吗,用min吗?
select * from 表名 where 学分<(select 学分 from 表名 where 课程名='计算机网络')
查询select * from student where score between 50 and 60
改成绩
update student set score=score+5 where score between 50 and 60
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)