怎样使结果只保留小数点后两位
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
结果出来后,小数点后保留了好多位。怎样只显示小数点后两位
请多指教
新手