Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 13 of 79

Database Query using SQL — Question 5

Back to all questions
5
Question

Question 5

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

Answer 
SELECT * FROM emp 
LEFT JOIN
SELECT * FROM emp1;