what does mean by self join ?

Question

why it is in not this SQL app ?

Answer 1

The SQL SELF JOIN is used to join a table to itself as if the table were two tables, temporarily renamed.

Answer 2

for example same table contains employee and manager.we can go with self join

Answer 3

It is used to Join a table to itself.

Answer 4

joining a table with same table.

Answer 5

joining a table to itself and avoiding duplicate datas

Answer 6

Self joined is basically used to join a table by itself as we join other tables (temporarily joined)

Answer 7

please give a sample query to get some idea about self join