方法1:

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

方法2:

SELECT name, RIGHT(certid,4) as certid

FROM mjsxd_newuser_day

posted on 2018-11-20 11:11  巨象  阅读(6348)  评论(0编辑  收藏  举报