ROW_NUMBER - sequential number of a row

SELECT col2, ROW_NUMBER() OVER (ORDER BY col1) FROM T

SELECT aaaaa, ROW_NUMBER()  OVER (PARTITION BY columnX ORDER BY columnY DESC) as rn
FROM TableT
where ........