How to Set Sr. No 1 in each month of attendance.

Question

Hi,

how to gererate sr no starting from 1 when each Month Change or

each financial year change means(1-4-17 to 31-3-18). in sql or c#