将employees表的所有员工的last_name和first_name拼接起来作为Name

 

题目链接

mysql版本： 

SELECT CONCAT(last_name, " ", first_name) AS NAME 
FROM employees;

 

SQLite版本： （SQLite没有concat函数， 通过 || 来实现字符串连接）

SELECT last_name || " " || first_name AS Name
FROM employees;