Simonesql语句中如何将数值格式输出
的有关信息介绍如下：
select convert(decimal(38,2), AA.a )
from
(
select 1.1111 as a
union
select 1.2222 as a
union
select 1.3333 as a
union
select 1.5555 as a
) as AA
你这里的话用convert(decimal(38,2), sum(hf)/100 )as res_je 就可以了
decimal(38,2) 意思是38位的数字，其中2位是小数位
统一输出的话，最好在SQL字段里设置位数
select CAST(Sub_name,Sum(hf)/100 AS Decimal(18,2)) AS Res_je
FROM SSS
