Informatics Practices
How can we fetch only common records from two tables emp and emp1?
SQL Queries
3 Likes
Answer
SELECT * FROM emp
INTERSECT
SELECT * FROM emp1;
Answered By
2 Likes
Related Questions
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.