How to find duplicates in 2 joined tables

Database
Enthusiast

How to find duplicates in 2 joined tables

Hi 

I've joined 2 tables that have similar data with some data duplicated how can i find the duplicated data please help thank you 

Tags (1)

Accepted Solutions
Teradata Employee

Re: How to find duplicates in 2 joined tables

Hi Blazio,

 

The general query to find duplicates is this one :

  select column1 [, column2, ...]
, count(*) from table1
[ join table2 on ... ] group by column1 [, column2, ...] having count(*) > 1;
1 ACCEPTED SOLUTION
2 REPLIES 2
Teradata Employee

Re: How to find duplicates in 2 joined tables

Hi Blazio,

 

The general query to find duplicates is this one :

  select column1 [, column2, ...]
, count(*) from table1
[ join table2 on ... ] group by column1 [, column2, ...] having count(*) > 1;
Enthusiast

Re: How to find duplicates in 2 joined tables

Hi

 

Walder thank you for that it worked!