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.
Battery coating is the process of applying uniform layers of active materials—such as cathode and…
Let’s face it. Tech buzzwords get thrown around a lot—especially when it comes to how…
In today’s digital world, the boundaries between technology, finance, and innovation are rapidly disappearing. Businesses…
Backyard gatherings like BBQs, family reunions, and garden parties are an exciting way to enjoy…
Marketers are always on the lookout for more effective ways to reach their target audiences.…
Does your phone control your mind more than you control your phone? Modern life exploits…