This sample demonstrates the use of the
distinct
qualifier with thesum()
function. Note the use of theexplain
command to display the execution plan.This sample can be run from directory
samples\xsql\scripts
with the following command:..\..\..\target\bin\xsql.exe -b -c xsql.cfg -f distinctsum.sql