What is semi join in SQL?

Answer 1

A semi-join returns rows from one table that would join with another table without performing a complete join. It doesn't have explicit syntax.

Eg : semi join to evaluate an exists sub query

select *

from Customers C

where exists (

select *

from Sales S

where S.Cust_Id = C.Cust_Id

)

Cust_Id Cust_Name

----------- ----------

2 John Doe

3 Jane Doe

Answer 2

A semi join in SQL compares two tables and returns rows from the first table where a match is found in the second table, but only the columns from the first table are included in the result. It is commonly used to filter results based on a condition in another table without duplicating data.