Informatics Practices
How can we retrieve all records of emp that are not present in emp1?
SQL Queries
1 Like
Answer
SELECT * FROM emp
LEFT JOIN
SELECT * FROM emp1;
Answered By
2 Likes
Related Questions
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 fetch only common records from two tables emp and emp1?
Count the total salary deptno wise where more than 2 employees exist.
Suppose there is annual salary information provided by emp table. How can we fetch monthly salary of each and every employee?