How to generate serial no in sql

Sep 22 2017 12:31 PM

hi,....

how to generate serial no starting from 1 for each month chnage or each finacial year change means year no change when yr chnage as (1-4-17 to 31-3-18) in sql or c#