xSQL Sample Disgroup

This sample demonstrates the use of the distinct qualifier with an order by clause. Note the use of the echo command to display each SQL statement as it is executed and explain 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 disgroup.sql