计算机二级 20101113(13)

xianzaishijian:09:24:21

?"xianzairiqi:"+dtoc(date())

xianzairiqi:12-12-10

?year(date()) 2010

?year(date())*2 4020

?year(datetime())*2 4020

select student.学号,姓名,course.课程名,sc.成绩 from student,course,sc;

where student.学号=sc.学号 and course.课程号=sc.课程号;

order by 课程名,成绩 desc into table sclist