<div>
Oh ok, can you write me a basic SQL statement that does this. 
</div>


Oh ok, can you write me a basic SQL statement that does this.

<div>
please see example F on the linked page
</div>


<div>
@yguyon28:<br />
<br />
Do all columns in your table indicate a duplicate record? &nbsp;Or just a few columns?
</div>


@yguyon28:

Do all columns in your table indicate a duplicate record?  Or just a few columns?

<div>
Also, does your table have a primary key?
</div>


Also, does your table have a primary key?

<div>
<div class="content wysiwyg-content">
How do I write a Select Distinct statement that delete duplicate data from a table and dump the result to another table?
</div>
</div>


How do I write a Select Distinct statement that delete duplicate data from a table and dump the result to another table?

SQL SELECT DISTINCT Statement

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.