When migrate data you need to compare two tables and identify the unmatched results records.
Suppose you have two tables table1 and table2 with same columns and values. If any one table has any extra row then using below query you can get the unmatched results.
SELECT id, name FROM ( SELECT id, name FROM table1 UNION ALL SELECT id, name FROM table2 ) tbl GROUP BY id, name HAVING count(*) = 1 ORDER BY id;
Using above query you will get the unmatched row.
In today’s fast-paced and highly competitive marketing environment, even the most creative campaign is only…
We are NYC moving firm. Are you planning a flat move? Maybe a distance or…
Mobile devices, unlike desktops and laptops, can not be handled by dozens or hundreds of…
Augmented Reality- An immersive experience for the learners! Learning and education aren’t the same as…
On special days like birthdays and weddings, we all like to celebrate our loved ones…
A web application is different from a regular mobile or desktop application as it runs…