View Single Post
  #11 (permalink)  
Old 12-10-09, 10:23
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
Quote:
Originally Posted by shammat View Post
That's what I said
Right. But since this is a group about the ISO/ANSI standard, those product-specific things are irrelevant for answers with respect to what is or is not covered in ISO/ANSI SQL.

Quote:
I'd say there it never makes sense.
That's a strong statement. I don't know which requirements a certain application may have to need such a feature. So I would never be in a position to claim that it "never makes sense". But that's beside the point. The point is that grouping the result rows is an orthogonal concept to the SELECT list. The only dependency that exists is that aggregate functions are applied to a group defined by a GROUP BY clause. For everything else, there are no strings attached. That's what the standard requires and what products implement.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote