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.

BY Best Interview Question ON 19 Feb 2019

Example

SELECT T2.name

FROM category T1

JOIN category T2

ON T2.parent = T1.id

WHERE T1.name = 'Best interview questions.'

Suggest An Answer