select concat(last_name,' ',first_name) name
from employees

考察concat函数,将字符串连接起来