Breaking News: Grepper is joining You.com. Read the official announcement!

parent child hierarchy in sql

Rasel Ahmed answered on June 23, 2022 Popularity 6/10 Helpfulness 2/10

answer parent child hierarchy in sql

parent child hierarchy in sql

Comment

WITH RECURSIVE generation AS (
    SELECT id,
        first_name,
        last_name,
        parent_id,
        0 AS generation_number
    FROM parent_child
    WHERE parent_id IS NULL
 
UNION ALL
 
    SELECT child.id,
        child.first_name,
        child.last_name,
        child.parent_id,
        generation_number+1 AS generation_number
    FROM parent_child child
    JOIN generation g
      ON g.id = child.parent_id
)
 
SELECT first_name,
     last_name,
     generation_number
FROM generation;

Popularity 6/10 Helpfulness 2/10 Language sql

Source: learnsql.com

Tags: hierarchy parent-child sql

Link to this answer
Share Copy Link

Contributed on Jun 23 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

parent child hierarchy in sql

Contents

More Related Answers

parent child hierarchy in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.