是这样的,从表200608里面
列cd003相同的行数统计成cishu,列cd003相同的行数的列cd004数值相加,输出来
select [cd003] as taocai,c1 as cishu,s1 as feiyong into b8 from
(select cd003,count(*) c1,sum(cd004) s1 from 200608 group by cd003)
Order By cishu Desc
有错误,请大家帮忙看看
列cd003相同的行数统计成cishu,列cd003相同的行数的列cd004数值相加,输出来
select [cd003] as taocai,c1 as cishu,s1 as feiyong into b8 from
(select cd003,count(*) c1,sum(cd004) s1 from 200608 group by cd003)
Order By cishu Desc
有错误,请大家帮忙看看
[cd003] as taocai,
c1 as cishu,
s1 as feiyong
into b8 from
(
select cd003,count(*) c1,sum(cd004) s1 from 200608 group by cd003
)A
Order By cishu Desc
cd003 as taocai,
c1 as cishu,
s1 as feiyong
into b8 from
(
select cd003,count(*) c1,sum(cd004) s1 from [200608] group by cd003
)A
Order By cishu Desc
from(select [cd003],count(*) c1,sum(convert(money,cd004)) s1 from [200608] group by [cd003])A
order by cishu desc消息 235,级别 16,状态 0,第 1 行
无法将 char 值转换为 money。该 char 值的语法有误。
类型转换不成功,有什么办法吗?