What is ROW_NUMBER function in T-SQL?

ROW_NUMBER is a new function in T-SQL which is introduced in SQL
Server 2005. Basically, it returns the sequential number of a row
within a partition of a result set, starting at 1 for the first row in
each partition. It is very similar to the ROWNUM function in Oracle