Posts

Showing posts from March, 2021

Row_Number() in sql

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