求查询出来的数据只保留两位小数的语句

[ngzh0811]

我有个表01000,里面有个字段a,可能有多位小数，我想查询字段a，只保留两位小数，请教！

[chuifengde]

select str(a,15,2) a from [01000]

[子陌红尘]

select cast(round(a,2) as numeric(18,2)) from [01000]

[yangyangxie]

select cast(a as decimal(18,2)) from [01000]

[ngzh0811]

谢谢了！