Find expert answers and community-driven knowledge on IDNLearn.com. Get prompt and accurate answers to your questions from our experts who are always ready to help.

How can you avoid result truncation when the string_agg aggregation result exceeds the limit of 8000 bytes in SQL?
a. Use LOB (Large Object) types
b. Increase the limit in the database settings
c. Split the results into multiple columns
d. Use a different aggregation function


Sagot :