/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 vote265 views3 answers
Get all tables postgres
SQL
0 vote279 views1 answer
Updating database in sql
SQL
13 votes232 views3 answers
Uninstall mysql centos 7
SQL
1 vote244 views1 answer
Median mysql
SQL
0 vote273 views1 answer
Get initials name in sql
SQL
25 votes251 views4 answers
Metadata
SQL
0 vote258 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
-1 vote245 views3 answers
Mysql get age from date
SQL
8 votes260 views1 answer
Show mysql user table
SQL
0 vote242 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL