Javatpoint Logo
Javatpoint Logo

Oracle SELF JOIN

Self Join is a specific type of Join. In Self Join, a table is joined with itself (Unary relationship). A self join simply specifies that each rows of a table is combined with itself and every other row of the table.

Syntax

Oracle SELF JOIN Example

Let's take a table "customers".

Oracle Self Join

Join this table using SELF JOIN as follows:

Output

Oracle Self Join 2
Next TopicOracle CROSS JOIN




Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA