<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the grade.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
I am looking to find all the duplicates in our database based on duplicate upc code only if the uom = 'CA' or 'UOM' and not null.<br />
<br />

<pre><code id="code-10-27983886-1">part_code	uom	upc_code
PUR14192	CA	017800141888   
PUR14192	EA	017800141888
PUR14192	LB	NULL
PUR14192	PL	NULL
1428	        CA	052742142814
1428	        EA	052742142807
1428	        LA	NULL
1428	        LB	NULL
1428	        PL	NULL</code></pre>
<br />
So it would show as the output.<br />
<br />

<pre><code id="code-10-27983886-2">part_code	uom	upc_code
PUR14192	CA	017800141888   
PUR14192	EA	017800141888</code></pre>
<br />
<br />
Any help would be greatly appreciated.
</div>
</div>


I am looking to find all the duplicates in our database based on duplicate upc code only if the uom = 'CA' or 'UOM' and not null.

(CODE)

So it would show as the output.

(CODE)


Any help would be greatly appreciated.

Find Duplicates - SQL

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.