/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

1 vote175 views1 answer
Postgres set column based on another column
SQL
0 vote168 views1 answer
Changer un mot de passe mysql
SQL
0 vote161 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote202 views1 answer
Cahnge column name apex oracle
SQL
0 vote175 views2 answers
Sql update multiple tables
SQL
1 vote178 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
9 votes185 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote213 views1 answer
Postgres docs /copy metacomand
SQL
2 votes182 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote179 views1 answer
How many rows affected in sqllite
SQL