/SQL/How to find all children of a record with only parent ID in sql

How to find all children of a record with only parent ID in sql

DECLARE @Table TABLE(
        ID INT,
        ParentID INT,
        NAME VARCHAR(20)
)

INSERT INTO @Table (ID,ParentID,[NAME]) SELECT 1, NULL, 'A'
INSERT INTO @Table (ID,ParentID,[NAME]) SELECT 2, 1, 'B-1'
INSERT INTO @Table (ID,ParentID,[NAME]) SELECT 3, 1, 'B-2'
INSERT INTO @Table (ID,ParentID,[NAME]) SELECT 4, 2, 'C-1'
INSERT INTO @Table (ID,ParentID,[NAME]) SELECT 5, 2, 'C-2'


DECLARE @ID INT

SELECT @ID = 2

;WITH ret AS(
        SELECT  *
        FROM    @Table
        WHERE   ID = @ID
        UNION ALL
        SELECT  t.*
        FROM    @Table t INNER JOIN
                ret r ON t.ParentID = r.ID
)

SELECT  *
FROM    ret

Source: stackoverflow.com

Similar codes

2 votes310 views2 answers
Sql first character
SQL
0 vote295 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
2 votes312 views1 answer
Sql update \
SQL
6 votes315 views2 answers
Mysql interval 1 day
SQL
0 vote318 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote330 views1 answer
Postgresql like
SQL
0 vote285 views1 answer
Oracle execute immediate quotes
SQL
0 vote310 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote315 views1 answer
Get schema of table sql
SQL
0 vote292 views2 answers
Android sqlite tutorial for beginners
SQL