# 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