Posts Tagged common table expression
There are different methods to remove duplicates in SQL server 2005 where we do not have primary key defined for any table.
In the example I have table with field names FirstName and LastName. To remove duplicates in any table, replace the field names with the actual names.
If we have more columns, then add those columns as well in the declaration part and in the select and where conditions in the query.
Method 1 Read More
