40 query:cannot_group_without_agg
I got this message (CANNOT_GROUP_WITHOUT_AGG ... - iTecNote I how to fix this error message? Unable to parse query string for Function QUERY parameter 2: CANNOT_GROUP_WITHOUT_AGG. I got that error message just from a ... I got this message (CANNOT_GROUP_WITHOUT_AGG) from a simple query 1 Answer Sorted by: 11 If you don't have an agreggation function (such as sum, avg, count in SELECT ), there is no use for GROUP BY - you may just delete it. If you wish to present unique records, use distinct instead. Share Improve this answer Follow edited Jun 12, 2017 at 7:27 answered Jun 10, 2017 at 6:47 Dimgold 2,668 5 25 49
STRING_AGG (Transact-SQL) - SQL Server | Microsoft Learn STRING_AGG is an aggregate function that takes all expressions from rows and concatenates them into a single string. Expression values are implicitly converted to string types and then concatenated. The implicit conversion to strings follows the existing rules for data type conversions.
Quer