方法1:

select substr('123456789',length('123456789')-6+1,6) from dual;

方法2:

SELECT name, RIGHT(certid,4) as certid

FROM mjsxd_newuser_day

05-08 15:24