sql деление групп на подгруппы

sql-Деление групп на подгруппы.sql

/*
Деление групп на подгруппы
*/
select
	rawData
	,nt
	,ost
	,max(ost) over () as maxCountGroup
from
(
	select
		rawData
		,nt
		,((nt - 1 ) / 2/*это кол-во групп. по которым необходимо разбить*/) + 1 as ost
	from(

		select
			rawData
			,DENSE_RANK()  over ( order by rawData ) as nt
		from
		(
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 1 as rawData union all
			select 2 as rawData union all
			select 2 as rawData union all
			select 2 as rawData union all
			select 2 as rawData union all
			select 2 as rawData union all
			select 2 as rawData union all
			select 2 as rawData union all
			select 2 as rawData union all
			select 2 as rawData union all
			select 3 as rawData union all
			select 3 as rawData union all
			select 3 as rawData union all
			select 3 as rawData union all
			select 3 as rawData union all
			select 3 as rawData union all
			select 3 as rawData union all
			select 3 as rawData union all
			select 3 as rawData union all
			select 3 as rawData union all
			select 5 as rawData union all
			select 5 as rawData union all
			select 5 as rawData union all
			select 5 as rawData union all
			select 5 as rawData union all
			select 5 as rawData union all
			select 5 as rawData union all
			select 5 as rawData union all
			select 5 as rawData union all
			select 6 as rawData union all
			select 6 as rawData union all
			select 6 as rawData union all
			select 6 as rawData union all
			select 6 as rawData union all
			select 6 as rawData union all
			select 6 as rawData union all
			select 7 as rawData union all
			select 7 as rawData union all
			select 7 as rawData union all
			select 7 as rawData union all
			select 7 as rawData union all
			select 7 as rawData union all
			select 7 as rawData union all
			select 8 as rawData union all
			select 8 as rawData union all
			select 8 as rawData union all
			select 8 as rawData union all
			select 8 as rawData union all
			select 8 as rawData union all
			select 8 as rawData union all
			select 9 as rawData union all
			select 9 as rawData union all
			select 9 as rawData union all
			select 9 as rawData union all
			select 9 as rawData union all
			select 9 as rawData union all
			select 9 as rawData union all
			select 10 as rawData union all
			select 10 as rawData union all
			select 10 as rawData union all
			select 10 as rawData union all
			select 10 as rawData union all
			select 10 as rawData union all
			select 10 as rawData union all
			select 10 as rawData union all
			select 10 as rawData union all
			select 10 as rawData union all
			select 10 as rawData union all
			select 10 as rawData union all
			select 11 as rawData union all
			select 11 as rawData union all
			select 11 as rawData union all
			select 11 as rawData union all
			select 11 as rawData union all
			select 12 as rawData union all
			select 12 as rawData union all
			select 12 as rawData union all
			select 12 as rawData union all
			select 12 as rawData union all
			select 12 as rawData union all
			select 12 as rawData union all
			select 12 as rawData union all
			select 12 as rawData union all
			select 12 as rawData union all
			select 12 as rawData
		) t0
	) t0
) t0