Answer:
Self JOIN is a query that joins a table with itself. This is used to compare the values of a particular column with other values in the same column of the same table. Self JOIN uses aliases to name the original and duplicate tables.
| Previous Question | Next Question |
| Do you know what is a subquery? | Tell me what are the differences between primary and foreign keys? |