Re: [GENERAL] Baffled by "Group By" - Please help!

2001-03-24 Thread Tom Lane
"Matt Friedman" <[EMAIL PROTECTED]> writes: > What am I missing? I'm not seeing why this query doesn't group everything > and then return unique rows. Since you didn't show an example of the input and output, it's hard to tell what your gripe is ... but I'll venture that you didn't want to group

[GENERAL] Baffled by "Group By" - Please help!

2001-03-24 Thread Matt Friedman
For some reason, probably because I'm not understanding very well, I'm getting some duplicated rows for this query (below). My understanding is that "group by" brings all the rows together where the indicated columns are equal and then applies the aggregate to the column indicated; in this case: