Question: what are self joins in sql?
Answer: A SQL self join joins data from the same table. In other words, it joins a table with itself. Records taken from the table are matched to other records from the same table.