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 solution is

select t1.group, t2. subgroup

from table t1 inner join table t2 on t1.group = t2.group

order by t2.subgroup

but how to get only one record from each pair ?