Re: [SQLObject] DISTINCT and COUNT

[Andrew B. <and...@pu...>]

On Mon, Sep 13, 2004 at 06:01:09PM -0500, Ian Bicking wrote:
[...]
> 
> I'm still a little confused about what distinct really means.  No two 
> rows can be indistinct if you are including the primary key in the 
> select.  So what does distinct accomplish?  If you could select a subset 
> of the columns, then distinct would be useful.  That could be useful, 
> probably as another method (e.g., MyClass.selectColumns(['firstName', 
> 'lastName'])); and there distinct would make sense.

That would be good too.  But distinct on all columns can still be useful if
you're doing a join that might include the same row multiple times.

-Andrew.