統計分數
摘要：
SELECT CourseId,CourseName,CASE WHEN (Score<10) THEN 0 WHEN (10<=Score AND Score<20) THEN 10 WHEN (20<=Score AND Score<30) THEN 20WHEN (30<=Score AND Score<40) THEN 30WHEN (40<... 阅读全文
posted @ 2007-06-22 18:14 kenly33 阅读(153) 评论(0) 推荐(0) 编辑
