case OrderDate when OrderDate between '1999-1-1' and '2005-12-31' then 8.3 ??
case 里是否可以用 between and ?? 用between and 是 ok 的 冇问题啦
只是这语法不对,应该这样写:
case when OrderDate between '1999-1-1' and '2005-12-31' then 8.3 end ......记得 End