1. 题目
-
题目描述
将employees表中的所有员工的last_name和first_name通过(’)连接起来。(sqlite不支持concat,请用||实现,mysql支持concat) -
表格
10001|1953-09-02|Georgi|Facello|M|1986-06-26 10002|1964-06-02|Bezalel|Simmel|F|1985-11-21 10003|1959-12-03|Parto|Bamford|M|1986-08-28 10004|1954-05-01|Chirstian|Koblick|M|1986-12-01 10005|1955-01-21|Kyoichi|Maliniak|M|1989-09-12 10006|1953-04-20|Anneke|Preusig|F|1989-06-02 10007|1957-05-23|Tzvetan|Zielinski|F|1989-02-10 10008|1958-02-19|Saniya|Kalloufi|M|1994-09-15 10009|1952-04-19|Sumant|Peac|F|1985-02-18 10010|1963-06-01|Duangkaew|Piveteau|F|1989-08-24 10011|1953-11-07|Mary|Sluis|F|1990
-
所需结果
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(last_name,'\'' ,first_name) name
FROM employees