题解 | RIGHT函数:从字符串中提取多个字符(从右开始)
获取employees中的first_name
https://www.nowcoder.com/practice/74d90728827e44e2864cce8b26882105
select e.first_name first_name from(select first_name,right(first_name,2) r2 from employees) e order by e.r2
获取employees中的first_name
https://www.nowcoder.com/practice/74d90728827e44e2864cce8b26882105
select e.first_name first_name from(select first_name,right(first_name,2) r2 from employees) e order by e.r2
相关推荐