On 7/18/12 5:41 PM, Ken Dibble wrote: > Well there's a small subset of situations where the results of a particular > query are completely predictable and it's just annoying to have to echo all > the fields in the fields clause in the group by clause when it won't > actually affect the validity of the result in a particular KNOWN case.
I agree. SQL should have a GROUP BY IMPLICIT option that tells the engine to group by all non-aggregate fields. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
