字符串操作:字符串提取 first_name 后两个字符 按照后两个字符升序排序
select first_name
from (select first_name, right(first_name,2) str
from employees) t
order by str;
字符串操作:字符串提取 first_name 后两个字符 按照后两个字符升序排序
select first_name
from (select first_name, right(first_name,2) str
from employees) t
order by str;