[Solved] What is the main purpose of a self join in SQL? — Ans: To join a table to itself to compare rows within the same table | SQL

SQL - INNER JOIN

What is the main purpose of a self join in SQL?

ATo combine rows from two tables without any condition

BTo join two different tables based on a common column

CTo join a table to itself to compare rows within the same table

DTo delete duplicate rows from a table

Step-by-Step Solution

Solution:

Step 1: Understand the concept of self join
A self join is used when you want to compare rows within the same table by treating it as two separate tables using aliases.
Step 2: Identify the correct purpose
Joining a table to itself allows you to find relationships or comparisons between rows in the same table, such as hierarchical data or pairs.
Final Answer:
To join a table to itself to compare rows within the same table -> Option C
Quick Check:
Self join = join table to itself [OK]

Quick Trick: Self join means joining table to itself using aliases [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What is the main purpose of a self join in SQL?