Could you please help me to search for duplicate records across all tables in a MySQL database?
There are multiple tables in a database. Tables contain 10 columns including username VARCHAR), dateofbirth (VARCHAR) and pincode (INT)
I need a query that will do the following:-
Find records (matched on username and dateofbirth) that appear 2 times or more across all of the tables AND where pincode <> "10001"