Explain self joins in oracle?

1.	Explain self joins in oracle?
Answer» 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. Example SELECT T2.name FROM category T1 JOIN category T2 ON T2.parent = T1.id WHERE T1.name = 'Best INTERVIEW QUESTIONS.'

Answer»

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.

Example

SELECT T2.name

FROM category T1

JOIN category T2

ON T2.parent = T1.id

WHERE T1.name = 'Best INTERVIEW QUESTIONS.'

Discussion