题解 | RIGHT提取右边指定长度字符串
获取employees中的first_name
https://www.nowcoder.com/practice/74d90728827e44e2864cce8b26882105
select first_name
from (
select first_name, RIGHT(first_name, 2) as last_two_string
from employees
order by last_two_string
) as a;
查看3道真题和解析
投递农夫山泉等公司10个岗位 >