In this post i will show an example of how to select or return only duplicate records in SQL Server. I have a table named [TBL_DUPLICATEDATA] which has duplicate records. Using Common Table Expression (CTE) , one can select only duplicate records in sql server along with its primary key values (which is id column). […]