This sample demonstrates the use of the
string_agg()
function. Note the difference in the execution plans displayed by theexplain
command.This sample can be run from directory
samples\xsql\scripts
with the following command:..\..\..\target\bin\xsql.exe -b -c xsql.cfg -f stringagg.sql