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

Database Query using SQL — Question 4

Back to all questions
4
Question

Question 4

How can we fetch only common records from two tables emp and emp1?

Answer 
SELECT * FROM emp 
INTERSECT 
SELECT * FROM emp1;