79739964

Date: 2025-08-19 13:29:18
Score: 3
Natty:
Report link

GROUP_CONCAT worked perfectly. Thanks @MatBailie. I'm still a little unclear on the differences between LISTAGG, STRING_AGG, and GROUP_CONCAT but I very much appreciate the help!

Updated code:

SELECT ToolGroup, GROUP_CONCAT(', ', ToolID) AS ActiveTools
FROM DB
GROUP BY ToolGroup
ORDER BY ToolGroup
Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Low length (0.5):
  • Has code block (-0.5):
  • User mentioned (1): @MatBailie
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: wawiti