View Slide
CREATE TABLE Employee (id int primary key,name varchar(255) not null,manager_id int);
SELECT m.nameFROM Employee eINNER JOIN Employee mON e.manager_id = m.idWHERE e.id = 100;
WITH RecursiveCte AS (SELECT e.id, e.nameFROM Employee eWHERE parent_id = 100UNION ALLSELECT e.id, e.nameFROM Employee eINNER JOIN RecursiveCte rcteON e.parent_id = rcte.id)SELECT Name FROM RecursiveCte;
MATCH(e { id: 100 })-[:MANAGED_BY]->(m)RETURN m.name;
MATCH(m { id: 100 })<-[:MANAGED_BY*]-(e)RETURN e.name;