Sql筛选小数位为2的记录

select amount_receivable_residual,id from cms_settlement where "length"(cast((cast(amount_receivable_residual as numeric) % 1) as varchar))-2 >2