Select all records where dept no of both emp and dept table matches.

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?

How can we retrieve all records of emp that are not present in emp1?

Count the total salary deptno wise where more than 2 employees exist.