题解 | #将employees表中的所有员工的last_name和first_name通过引号连接起来。#
将employees表中的所有员工的last_name和first_name通过引号连接起来。
http://www.nowcoder.com/practice/810bf4ee3ac64949b08983aa66ec7bee
select CONCAT(e.last_name,"'",e.first_name) as name from employees e # 方法二 转义 # SELECT concat(last_name,'\'',first_name) AS name # FROM employees;
查看8道真题和解析