>In the case of a CNT(*) I would expect that the "correct" record would be one where ALL other
>non-field-function values in the SELECT are the same regardless of whether they are in the
>GROUP BY or not.

I don't understand what you're getting at here. Can you post a simple SELECT and data (5 fields, 5 rows, say) that show what you mean?