select convert(numeric(2,0),count(T2.cardcode)) from oopr T2 inner join opr1 T1 on T1.opprid=T2.opprid inner join ocrd
T3 on T3.cardcode=T2.cardcode
where T2.slpcode=OSLP.slpcode and (t3.phone1<>'' or t3.phone2<>'' or t3.cellular<>''))/(select count(cardcode) from opr1 T1 inner join oopr T2 on T1.opprid=T2.opprid where
T2.slpcode=OSLP.slpcode结果出来后,小数点后保留了好多位。怎样只显示小数点后两位
请多指教 新手
T3 on T3.cardcode=T2.cardcode
where T2.slpcode=OSLP.slpcode and (t3.phone1<>'' or t3.phone2<>'' or t3.cellular<>''))/(select count(cardcode) from opr1 T1 inner join oopr T2 on T1.opprid=T2.opprid where
T2.slpcode=OSLP.slpcode结果出来后,小数点后保留了好多位。怎样只显示小数点后两位
请多指教 新手
小数点左边和右边数字之和,不包括小数点。如 123.45,则 p=5,s=2。
指定精度或对象能够控制的数字个数。s
指定可放到小数点右边的小数位数或数字个数。
select cast(count(T2.cardcode) as dec(30,2)) from oopr T2