Apply Row Number in a query
select *, row_number() over(order by intID )as RowNumber from TableName You can also use d Partition By in place of Order by to used partition select *, row_number() over(partition by intID )as RowNumber from TableName