substr分割字符串
获取Employees中的first_name
http://www.nowcoder.com/questionTerminal/74d90728827e44e2864cce8b26882105
select e.first_name from employees e order by substr(e.first_name,-2);
substr可分割字符串,将倒数后两个字符串分割出来,然后进行排序即可
substr(字段,指定分割位置,长度)
获取Employees中的first_name
http://www.nowcoder.com/questionTerminal/74d90728827e44e2864cce8b26882105
select e.first_name from employees e order by substr(e.first_name,-2);
substr可分割字符串,将倒数后两个字符串分割出来,然后进行排序即可
substr(字段,指定分割位置,长度)
相关推荐