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.
People usually stumble onto the 461 visa when they realise there’s no simple way to…
In today’s digital era, people look for convenience, transparency, and genuine rewards from their financial…
If you are planning to start a lighting business and looking for a supplier of…
If you are a copywriter or a content marketer, you will second my statement that…
Motorcycle accidents often lead to severe injuries because riders have minimal protection compared to drivers…
No business owner starts his or her business with the hope of making losses. Everyone…