select A.* from table A

inner join

(

select distinct

group,

(select top 1 subgroup from table t where table.group=t.group order by subgroup) as subgroup

from table as A

) B

on A.group=B.group and A.subgroup=B.subgroup