/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 vote333 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
1 vote346 views3 answers
Rows, INSERT INTO
SQL
3 votes313 views2 answers
Oracle sql drop sequence
SQL
2 votes708 views1 answer
Oracle virtual column
SQL
0 vote338 views1 answer
Select insert new table sql server
SQL
0 vote378 views1 answer
Fetching data from mysqldb
SQL
0 vote343 views1 answer
Oracle service name view
SQL
0 vote345 views2 answers
Mysql where in maintain order group_concat
SQL
24 votes325 views5 answers
Sql server insert into select
SQL
0 vote338 views4 answers
Forenkey code alchemy sql
SQL