LEFT(s,n)返回字符串 s 的前 n 个字符

RIGHT(s,n)返回字符串 s 的后 n 个字符

right

select first_name
from employees
order by right(first_name, 2)

substr / substring

select first_name 
from employees  
order by substr(first_name,-2)