Forum Discussion
Removing Duplicates on a primary key-less table
Hi, I tried to remove duplicates from a table which contains a primary key. It seems there are various ways to tackle this situation. I tried using CTE (Common Table Expressions) and Row_Number f...
rohitnair your primary key increment auto? Please check the link
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property?view=sql-server-2017