A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
Partition By clause is not mandatory.
select *, Row_number() Over (order by salary desc) rn from emp-- this query just assign sequential number after the data sorted on sal column in descending order...
Gender-wise Salary rankings:
select *, Row_number() Over (partition by gender order by salary desc) rn from emp-- this query assigns ranks once after data partioned on gender column