Re:Do you use GROUP BY correctly?
by Jare on Tuesday May 15, 2012 @08:18PM
(#3979674)
I often include such columns during ad-hoc analytics, because it is one valid example of the data being grouped. In particular, when COUNT(*) is 1 the value in that column is THE value, and thanks to including it in the query, I already have it. It's very convenient with very low cost.
For queries that are part of a formal process or application it's harder to find a use case.
For queries that are part of a formal process or application it's harder to find a use case.