Duplicates

[thembela]

I’ve just found out that some information has been entered more than once in the Customer Name & Plant Filed .So Now what I want to do is to write a query that will give me only the Customer names & Plant that were entered more than once. And leave out the Names that were entered once.This is an example of my data base below:



Cust_No Customer Name Plant
0001 Mobil Oil 89
0002 Mobil Oil 89
0003 Mobil Oil 89
0004 Texas 70
0005 Texas 70
0006 Petro 50
0007 Enron 20
0008 Gesco 30

 

[r937]

select [Customer Name]
     , Plant
     , count(*) as dupes
  from yourtable
group
    by [Customer Name]
     , Plant
having count(*) > 1

r937.com | rudy.ca