/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

0 vote315 views1 answer
Mysql create index lost connection
SQL
0 vote305 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote273 views1 answer
Postgres : ERROR: division by zero
SQL
1 vote268 views1 answer
Mysql get character set
SQL
4 votes270 views3 answers
Order by value mysql
SQL
1 vote281 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote278 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote243 views1 answer
SQL server select to get sum of hours
SQL
1 vote272 views1 answer
Insert column after column mysql
SQL
49 votes339 views6 answers
Mysql add column to table
SQL