<div>
How do you determine the original? &nbsp;Is there an identity field?<br />
<br />
if so, you can use<br />
<br />
DELETE FROM plant<br />
WHERE PlantID NOT IN (<br />
SELECT MIN(PlantID), Certificate<br />
GROUP BY Certificate)<br />

</div>


How do you determine the original?  Is there an identity field?

if so, you can use

DELETE FROM plant
WHERE PlantID NOT IN (
SELECT MIN(PlantID), Certificate
GROUP BY Certificate)


<div>
If I have 10 certificates as follows:<br />
<br />
10003<br />
10004<br />
10005<br />
10006<br />
10007<br />
10008<br />
10009<br />
10010<br />
10011<br />
<br />
Now the certificates 10003 and 10007 are duplicated.<br />
<br />
There should NEVER be two of the same numbers in this column.<br />
<br />
Is there a way to delete the dulpicate or set it to flag it some how?? &nbsp;IE highlight etc??
</div>


If I have 10 certificates as follows:

10003
10004
10005
10006
10007
10008
10009
10010
10011

Now the certificates 10003 and 10007 are duplicated.

There should NEVER be two of the same numbers in this column.

Is there a way to delete the dulpicate or set it to flag it some how??  IE highlight etc??

<div>
<div class="content wysiwyg-content">
I have a table called plant. &nbsp;A column called certificate.<br />
<br />
Is there a way to check the column certificate for duplicates and remove all but one original??<br />
<br />

</div>
</div>


I have a table called plant.  A column called certificate.

Is there a way to check the column certificate for duplicates and remove all but one original??



SQL Server 2008 search for and remove dulpicates

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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.