|< < 18 > >|

Join

Recursive schema and query

Schema:
create table Employee( emp_id int not null primary key, name varchar not null, boss_id int references Employee );

  • boss_id int references Employee: Foreign key to the same table.

|< < 18 > >|