Adding row number to SQL select result

SELECT ROW_NUMBER() OVER (ORDER BY Column1) AS 'Row',
Column1, COUNT(*), SUM(Column2)
FROM Table1