Group by sets in a list.

SELECT * FROM ( , ... , ... , ROW_NUMBER() OVER ( PARTITION BY column_1 -- group by this column ORDER BY column_2 DESC -- order by this column ) AS [Position] ) AS [Grouped_List]