JOIN NOW

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

3 Likes

Related Questions