Guest User

Untitled

a guest
Dec 8th, 2019
87
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. WITH RECURSIVE component AS (
  2. SELECT
  3. name1
  4. FROM
  5. metric2
  6. WHERE
  7. name1 = 'Makoto Takizawa 0001'
  8. UNION
  9. SELECT
  10. p2.name1
  11. FROM
  12. metric2 p2
  13. INNER JOIN component p1 ON p2.name2 = p1.name1
  14. ) SELECT
  15. COUNT(*)
  16. FROM
  17. component;
RAW Paste Data