lets say we have a table called employees, and we want t query and combine the id, name, work_date rows into one. you can use something like this:

SELECT CONCAT(id, name, work_date) FROM employees WHERE employeeId = 2;