请问我想将sql中计算的结果保留两位有效数字，怎么做？

[gsk99]

比如：
select substring('0.129456789',0,5)as abc from sc011

我想得到的结果是
abc
0.13

谢谢指教

[lxw99]

select round(cast('0.129456789' as float),2) 是正确的

（所影响的行数为 1 行）

SQL Server-----------------------------------------------------

[lxzm1001]

round

[lxzm1001]

select round(10.1296,2)

[churchatp1]

select round(cast('0.129456789' as interger),2)as abc from sc011

[mislrb]

select round(cast(substring('0.129456789',0,6) as float),2) as abc from sc011

[churchatp1]

select round(cast('0.129456789' as decimal(20,2)),2)as abc from sc011

[ls_jingwen]

select round(cast('0.129456789' as float),2)
結果:
-----------------------------------------------------
0.13

(影響 1 個資料列)