Question

将2000以后的成绩大于90分的学生成绩存入永久成绩表;将2000年以前的成绩存入临时

数据库方面的

Answer 1

程海涛 ,select score into asd from student_course inner join student on
student_course.sno=student.sno where score>90 and entime>2000
select score into #aa from student_course inner join student on
student_course.sno=student.sno where entime>2000

追问

你是？
黄梦龙？？？

追答

select score into asd from student_course inner join student on
student_course.sno=student.sno where score>90 and entime>2000
select score into #aa from student_course inner join student on
student_course.sno=student.sno where entime>2000