types of joins ,diff btw tuples and sets and all that

Question

Accepted Answer

Types of joins in SQL include inner join, outer join, left join, right join. Tuples are ordered collections while sets are unordered collections.

Types of joins in SQL: inner join, outer join, left join, right join
Tuples are ordered collections with duplicates allowed
Sets are unordered collections with no duplicates allowed
Inner join returns rows when there is at least one match in both tables
Outer join returns all rows when there is a match in one of the tables
Left join returns all rows from the left table and the matched rows from the right table
Right join returns all rows from the right table and the matched rows from the left table

Popular interview questions of Data Analyst