Question

SQL 两整数相除，取小数点后两位

cast(A.Fee/(@AllIncome+0.0) as decimal(9,2))，A.Fee和@AllIncome都是int型的，相除后怎么取到小数点后两位？

Answer 1

用函数ROUND(字段,精度)SqlServer Oracle通用

Answer 2

select cast(A.Fes/@Allncome as decimal(9,2)) from 表

Answer 3

cast( as (9,2))-round()

Answer 4

cast(round(A.Fee/(@AllIncome+0.0)/9 ,2) as numeric(9,2))