Hello, try these ones
1.
SELECT *
FROM emp
WHERE NOT EXISTS (SELECT emp_old.roll_no, emp_old.name
FROM emp_old
WHERE emp_old.roll_no = emp.roll_no AND
emp_old.name = emp.name)
2.
SELECT emp.*
FROM emp
LEFT JOIN emp_old
ON emp_old.roll_no = emp.roll_no AND
emp_old.name = emp.name
WHERE emp.name IS NULL