SELECT CONCAT(last_name , "'", first_name) as name
FROM employees;

注意一点，几乎每个sql软件都有不同的拼接方式。