方法1:select substr('123456789',length('123456789')-6+1,6) from dual;方法2:SELECT name, RIGHT(certid,4) as certidFROM mjsxd_newuser_day