Public Pastes
SHARE
TWEET

Untitled

a guest Dec 8th, 2019 81 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top