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)
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)