If there are two tables emp and emp1, and both have common records, how can we fetch all the records but common records only once?
SELECT * FROM emp UNION SELECT * FROM emp1;
