Technology ->
Database
2020-12-07 03:13:23
Self-join
1903
Introduction to Oracle Database Oracle Tables and Data definition Modifying data Oracle Query and Filter Oracle data types Joining tables Oracle Operators Grouping data Constraints
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;
Session is expired,Please login .