use CTE's Below is the syntax

With CTE As

(

Select *,Row_Number() Over(Partition By Col1,Col2 Order by Col1) From TableName

)

Select * From CTE