I've joined 2 tables that have similar data with some data duplicated how can i find the duplicated data please help thank you
Go to Solution.
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;
Walder thank you for that it worked!