摘要: SQL 保留两位小数的各种方法1.求和后,保留两位sum(cast(cc.OrderDateCount as decimal(10, 2)))2.平均值,保留小数CONVERT(decimal(10,2),avg(case when cc.ReceiveDateSum=0 then cc.Recei... 阅读全文
posted @ 2013-08-22 17:19 呓语 阅读(1467) 评论(0) 推荐(0) 编辑
welcome to this garden! --Chenly