0 votes
in Oracle by
Q. What is Semijoin? How to implement it in SQL?

1 Answer

0 votes
by

Ans is 

Semijoin returns records from the left table which match with the right table. Even if there are multiple matching records on the right table, the Semijoin returns a single record of the left table. It prevents duplications. Semijoin can be implemented using the WHERE EXISTS clause.

Related questions

0 votes
0 votes
asked Jul 29, 2020 in Oracle by Hodge
0 votes
asked Jul 29, 2020 in Oracle by Hodge
0 votes
asked Jul 29, 2020 in Oracle by Hodge
...