【牛客SQL】SQL32 将employees表的所有员工的last_name和first_name拼接起来作为Name

题目描述

题解

主要考察字符串拼接

sqlite

SELECT (last_name || ' ' || first_name) AS Name FROM employees;

MySQL:

SELECT CONCAT_WS(' ', last_name, first_name) AS Name FROM employees;