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