Adding row numbers to SQL results

SELECT 
	ROW_NUMBER() OVER (PARTITION BY GROUPING_COL ORDER BY ID_COL) AS rn,
	ID_COL, 
	GROUPING_COL, 
	SOME_VALUE,
	SOME_VALUE2
FROM SQL_TABLE

Bookmark the permalink.