How to generate serial no in sql

Question

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#

 

plz ans....