【数据库SQL实战】将employees表的所有员工的last_name和first_name拼接起来作为Name

https://www.nowcoder.com/practice/6744b90bbdde40209f8ecaac0b0516fe?tpId=82&tqId=29800&rp=0&ru=%2Fta%2Fsql&qru=%2Fta%2Fsql%2Fquestion-ranking

将employees表的所有员工的last_name和first_name拼接起来作为Name，中间以一个空格区分
CREATE TABLE employees ( emp_no int(11) NOT NULL,
birth_date date NOT NULL,
first_name varchar(14) NOT NULL,
last_name varchar(16) NOT NULL,
gender char(1) NOT NULL,
hire_date date NOT NULL,
PRIMARY KEY (emp_no));

MySQL、SQL Server、Oracle等数据库支持CONCAT方法，
SQLite数据库只支持用连接符号”||”来连接字符串

select last_name||" "||first_name as Name
from employees