Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

No content

Slide 3

Slide 3 text

No content

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

No content

Slide 7

Slide 7 text

No content

Slide 8

Slide 8 text

No content

Slide 9

Slide 9 text

CREATE TABLE Employee ( id int primary key, name varchar(255) not null, manager_id int );

Slide 10

Slide 10 text

SELECT m.name FROM Employee e INNER JOIN Employee m ON e.manager_id = m.id WHERE e.id = 100;

Slide 11

Slide 11 text

WITH RecursiveCte AS ( SELECT e.id, e.name FROM Employee e WHERE parent_id = 100 UNION ALL SELECT e.id, e.name FROM Employee e INNER JOIN RecursiveCte rcte ON e.parent_id = rcte.id ) SELECT Name FROM RecursiveCte;

Slide 12

Slide 12 text

No content

Slide 13

Slide 13 text

MATCH (e { id: 100 })-[:MANAGED_BY]->(m) RETURN m.name;

Slide 14

Slide 14 text

MATCH (m { id: 100 })<-[:MANAGED_BY*]-(e) RETURN e.name;

Slide 15

Slide 15 text

MATCH (m { id: 100 })<-[:MANAGED_BY*]-(e) RETURN e.name;

Slide 16

Slide 16 text

No content

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

No content

Slide 19

Slide 19 text

No content

Slide 20

Slide 20 text

No content

Slide 21

Slide 21 text

No content

Slide 22

Slide 22 text

No content

Slide 23

Slide 23 text

No content

Slide 24

Slide 24 text

No content

Slide 25

Slide 25 text

No content

Slide 26

Slide 26 text

No content

Slide 27

Slide 27 text

No content

Slide 28

Slide 28 text

No content