Self-join
Oracle Database Basic Course
Created by :
Database, Oracle
course
Programming, Software and application
1756
2020-12-07 03:13:23
A self JOIN is a regular join, but the table is joined with itself. A self join simply specifies that each rows of a table is combined with itself and every other row of the table.
Syntax
SELECT a.column_name, b.column_name... FROM table1 a, table1 b WHERE a.common_filed = b.common_field;

- Database Overview
- What Is Oracle Database
- History of Oracle Database
- Why Oracle Database
- Features of Oracle Database
- Oracle Vs. SQL Server: Key Differences
- Oracle Vs. MySQL Server: Key Differences
- Oracle Vs. NoSQL
- Install Oracle Database Server
- Oracle Database Sample Schema
- Execute Sample Database
- Connect to SQL Developer and Other SQL Editor