题目描述
将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有函数concat(s1,s2...sn)可用,SQLite数据库用连接符号"||"来连接字符串。
Mysql:
SELECT
concat(first_name, ' ', last_name) AS NAME
FROM
employees;
Sqlite:
SELECT
last_name || ' ' || first_name AS NAME
FROM
employees;