To Find The Duplicate Data in The Table??

Sabarimahesh
Posted by Sabarimahesh under Sql Server category on | Points: 40 | Views : 1163
By Using This Query You Can Easily Find the Duplicate Data

WITH Temporary_table (Empid,Sub_id, Count_Duplicate)
AS
(
SELECT Empid,Sub_id,ROW_NUMBER() OVER(PARTITION BY Empid,Sub_id ORDER BY Empid) AS Count_Duplicate FROM Emp_table
)

Comments or Responses

Login to post response