^^
With tempTable as ( Select * from table 1
Union all
Select * from table 2)
With Addabaj as ( Select name, email, address, count(*) from tempTable
group by name, email, address
having count(*) = 1 )
With junAddabaj as ( Select name, email, address, count(*) from tempTable
group by name, email, address
having count(*) > 1 )
With cleanTable as ( Select name, email, address from Addabaj
Union all
Select name, email, address from junAddabaj)
** eita db2 sql er code dilam, mysql er temp table create kora ta ektu diff hoite pare |