Find Dublicated rows.sql
WITH CTE AS
(
SELECT [Id], [EmployeeID] ,[EmployeeCode], UserName ,ROW_NUMBER() OVER (PARTITION BY EmployeeCode ORDER BY EmployeeCode) AS RN
FROM [GLCFlowNewDB].[GLCFlowSecurity].[AspNetUsers] AS t
)
select * from cte r
where r.RN>1