Answers for "group_concat with join query in sql"

how to use group_concat in sql server

SELECT STRING_AGG(column_name, ',') AS Result
FROM table_name

Posted by: Guest on August-27-2020

group_concat in mysql

GROUP_CONCAT(eng_category_name SEPARATOR ',') as eng_category_name

Posted by: Guest on February-26-2021

group_concat sql server

SELECT emp_id, fname, lname, dept_id, 
GROUP_CONCAT ( strength ) as "strengths" 
FROM employee group by emp_id;

Posted by: Guest on June-20-2021

Code answers related to "group_concat with join query in sql"