Question

sql语句中如何将数值格式输出

我经常对sqlserver2000数据库统计数值，下面是我写的语句：
select sub_name,sum(hf)/100 as res_je from sss;
在输出的结果中，res_je的值常有小数点后4位数，我想把res_je统一按小数位2位的格式输出，有什么函数或办法？
请大侠指教，谢谢！

Answer 1

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位是小数位

Answer 2

统一输出的话，最好在SQL字段里设置位数

Answer 3

select CAST(Sub_name,Sum(hf)/100 AS Decimal(18,2)) AS Res_je
FROM SSS