SELF JOIN in Oracle

SELF JOIN
The Oracle SELF Join query is used to join a table with itself, i,e, each row is combined with itself and every other rows of the table.

Syntax:

SELECT A.columns, B.columns   
FROM table_1 A, table_1 B   
WHERE A.common_filed = B.common_field;    

Example:
Students Table:

Query:

SELECT A.student_id, A.student_name, B.student_age  
FROM students A, students B
WHERE A.student_age < B.student_age;

Output:

Explanation:
The ‘students’ is an already existing table. After the joining, the selected fields of the rows of table A and table B will be displayed for which the student_age in table A is less than that in table B.