排序二

我的sql语句如下:
select Invoice_no ,sum(iif(depart_Code="AAA",Total_Amount,0)) as "AAA" ,sum(iif(depart_Code="DDD",Total_Amount,0)) as "DDD" ,sum(iif(depart_Code="YZH",Total_Amount,0)) as "YZH" From ConsumeData Group By Invoice_no

在SQl 2000 下执行错误:

第一行 = 号附近语法错.
以前该论坛上csdnm有类似回答.但在Sql 2000为何该语句不能执行.
上述语句中的字段均在表中已定义.
Email:[email protected]

答案为：

select * from tbCourse order by case term
when '一学期' then 1
when '二学期' then 2
...
when '八学期' then 8
end