Distinct in SQL

[bloggerman]

Do we always get a distinct in our query against non aggregated columns? Is there a way to not have it

I created a query with just country in it. It had a "select disticnt country....."

[tjohnson3050]

There is a property on the query called 'Auto Group and Sum'.  It is set to yes by default.  When this is set to yes, a query of one data item that has aggregation property set to none, will do a distinct.  Turn the property off, and you will not get a distinct.