使用 ROW_NUMBER 來實現群組編排序號

Select ROW_NUMBER() OVER(PARTITION BY gName ORDER BY gName DESC) AS 'Row Number',
gName
From @table