Home >>
MySql >> How to Concatenate Multiple Rows into One Column Using Group BY in MySql
How to Concatenate Multiple Rows into One Column Using Group BY in MySql
We use GROUP_CONCAT function to concatenate multiple rows into one column.
SELECT dept_id, GROUP_CONCAT(DISTINCT dept_name) AS department FROM employees GROUP BY dept_id;
Post Your Comment