[thelist] Query Quandry

Means, Eric D eric.d.means at boeing.com
Thu Apr 4 14:34:00 CST 2002


> Just a quick reminder, you cannot return row level detail in
> a summary query
> that uses GROUP BY.  Returning row level details will cause
> all sorts of
> nasty results.  In your query, all the columns in the select statement
> without Aggregate functions (except SONumber, which is
> specified in the
> GROUP BY clause and is therefore okay to select without an aggregate
> function) may cause the system to return unexpected information.

Perhaps I'm misremembering, but I thought you could GROUP BY more than one
column; in fact, I was under the impression that all non-aggregate columns
*had* to appear in the GROUP BY clause...?



More information about the thelist mailing list