Have you ever wanted to have a row count as a column in sql output?
Well, I have for a number of different reasons and this is how I found to do it.
ROW_NUMBER() OVER(Order by ‘SomeColumn’) as seq
Have you ever wanted to have a row count as a column in sql output?
Well, I have for a number of different reasons and this is how I found to do it.
ROW_NUMBER() OVER(Order by ‘SomeColumn’) as seq