I supposed wider problem - min() is not a good solution. In MsAccess there is group function FIRST()

and I may write:

select group, first(subgroup), ....

from table

group by group

I dont know similar

other...

I thought about this, but problem is - I have more fields - and for every filds I must prepare subquery.

In MSAcces there is group function FIRST and the...