CC字段的值是11，有没有办法可以使CC显示的值是11.61 心急人上

[penny417]

select a/b,a,b
from
(select 383 as a,33 as b) pp

CC字段的值是0，有没有办法可以使CC显示的值
是0.69
cc a b
---------------
11 13 33

有没有办法可以这样显示
cc a b
------------------
11.61 13 33

请帮帮手。

[Andy__Huang]

select cast(cast(a as numeric(10,2)/cast(b as numeric(10,2) numeric(12,2),a,b
from
(select 383 as a,33 as b) pp

[davorsuker39]

decimal 或 numeric

[zanyzyg]

格式化

[penny417]

hdhai9451(※★開拓者...糊涂中☆※)
那段代码执行有错啊！是不是写少了什么？

[aliren]

select cast(cast(a as numeric(10,2))/cast(b as numeric(10,2)) as numeric(10,2))as cc,a,b
from
(select 383 as a,33 as b) pp

[penny417]

解决了！谢谢各位