Hi you can using the CTE and Function of Ranking

Example :

;WITH Duplicate AS

(

SELECT

*, rownumber = ROW_NUMBER() OVER(PARTITION BY yourFieldvalue ORDER...