Learn Little bit More

It's very useful when using paging.In laymen, It will help us create a serial number. (e.g) Select Row_Number() over( partition by statename order by employeeid ) from employees