Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH RECURSIVE component AS (
- SELECT
- name1
- FROM
- metric2
- WHERE
- name1 = 'Makoto Takizawa 0001'
- UNION
- SELECT
- p2.name1
- FROM
- metric2 p2
- INNER JOIN component p1 ON p2.name2 = p1.name1
- ) SELECT
- COUNT(*)
- FROM
- component;
RAW Paste Data