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

1、题目描述

将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`));

输入描述:

无

输出描述:

Name

Facello Georgi

Simmel Bezalel

Bamford Parto

Koblick Chirstian

Maliniak Kyoichi

Preusig Anneke

Zielinski Tzvetan

Kalloufi Saniya

Peac Sumant

Piveteau Duangkaew

Sluis Mary    

 

2、代码：

select concat(concat(last_name,""),first_name) as Name
from employees;

 

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