如何向SQL中的重复数据集添加计数器?

I have a table which has a recurring field. I need a function to count and say which recurrence is in nth line. i.e.;I have a table which has a recurring field. I n