Answers for "sql join group data without group_concat"

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 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 "sql join group data without group_concat"