Usually, when I have a GROUP clause, and the select for the fields has to include additional fields, I simply use the MAX() syntax to add more fields which are not part of the group. However, I now need to include a bit field. A MAX() is not supported on a bit field. What would be the best approach to obtain that field in the field list?