sql="select sk_sales, sum(sk_yy) as total_amount,sum(case sk_branch when '旧单' then 1 else 0 end) as OldCnt from wz_result group by sk_sales order by sum(sk_yy) desc"我是这样写的.如果我不加sum(case sk_branch when '旧单' then 1 else 0 end)那就没错.加上这句就报错了.不知道是什么原因.
希望大家给出点意见
ASP+ACCESS开发的.
sk_sales,
sum(sk_yy) as total_amount,
sum(case sk_branch when '旧单' then 1 else 0 end) as OldCnt
from
wz_result
group by
sk_sales
order by
2 desc
sk_sales,
sum(sk_yy) as total_amount,
sum(case when sk_branch='旧单' then 1 else 0 end) as OldCnt
from
wz_result
group by sk_sales
order by sum(sk_yy) desc报啥错了
sum(sk_yy) as total_amount,
sum(case when sk_branch='旧单' then 1 else 0 end) as OldCnt
from wz_result
group by sk_sales order by sum(sk_yy) desc
sum(sk_yy) as total_amount,
iif(sk_branch="旧单",1,0) as OldCnt
from wz_result
group by sk_sales order by sum(sk_yy) desc
在access中不支持case when
而是用iif()看6楼的
(0x80004005)
未指定的错误 不管是写成sum(case when sk_branch='旧单' then 1 else 0 end) as OldCnt
还是写成 sum(case sk_branch when '旧单' then 1 else 0 end) as OldCnt
都是报这个错.
哈哈
他们都没有看到以为是sql的
其实是access的