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 solution may be
select group, first(subgroup), ....
from table
group by group
I don't know anything about such function in sqlserver
Second solution is to make join, but it need join
select t1.group, t2. subgroup
from table t1 inner join table t2 on t1.group = t2.group
order by t2.subgroup
but in this solution I want to get join 1 -1 not 1 to many