题解 | #employees表lname和fname拼接#
将employees表的所有员工的last_name和first_name拼接起来作为Name
https://www.nowcoder.com/practice/6744b90bbdde40209f8ecaac0b0516fe
select concat(last_name,' ',first_name) as name from employees;
使用mysql的函数concat()将连接条件加入进去即可完成连接
将employees表的所有员工的last_name和first_name拼接起来作为Name
https://www.nowcoder.com/practice/6744b90bbdde40209f8ecaac0b0516fe
select concat(last_name,' ',first_name) as name from employees;
使用mysql的函数concat()将连接条件加入进去即可完成连接
相关推荐