Loading…

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.

Example

                                        

SELECT T2.name

FROM category T1

JOIN category T2

ON T2.parent = T1.id

WHERE T1.name = 'Best interview questions.'

Suggest An Answer

No suggestions avaliable!

Latest post from Oracle Interview Questions

Ask Question