Explain self joins in oracle?
A self join means in a table each row is joined to other rows in the table and also to itself
Here, the standard JOIN command is used in which both the tables in the join are the same tables.
FROM category T1
JOIN category T2
ON T2.parent = T1.id
WHERE T1.name = 'Best interview questions.'