Multiple choice technology mainframe

What are the different types of JOINS?

  1. LEFT JOIN

  2. RIGHT JOIN

  3. FULL JOIN

  4. SELF JOIN
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

All four options are valid JOIN types in SQL. LEFT JOIN returns all rows from left table plus matching right table rows. RIGHT JOIN returns all rows from right table plus matching left table rows. FULL JOIN returns all rows when there's a match in either table. SELF JOIN joins a table to itself. All are standard SQL JOIN types.

Keep practicing — related questions