Breaking News: Grepper is joining You.com. Read the official announcement!

sql - Find all children who are not parent

Add Answer

e-mallz contact answered on December 3, 2021 Popularity 3/10 Helpfulness 4/10

answer sql - Find all children who are not parent

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

related sql - Find all children who are not parent

sql - Find all children who are not parent

Comment

SELECT ID, ParentID 
FROM [SMD].[dbo].[ProposalFollowUp] t1
WHERE NOT EXISTS
(
   SELECT 1 FROM [SMD].[dbo].[ProposalFollowUp] t2
   WHERE t2.ParentID = t1.ID
)

Popularity 3/10 Helpfulness 4/10 Language sql

Source: sqlerrors.com

Tags: children find parent sql

Link to this answer
Share Copy Link

Contributed on Sep 03 2022

e-mallz contact

0 Answers Avg Quality 2/10

Closely Related Answers

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

Comment

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

Popularity 5/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: record children sql find parent

Link to this answer
Share Copy Link

Contributed on Dec 03 2021

Encouraging Eagle

0 Answers Avg Quality 2/10

sql - Find all children who are not parent

Comment

WHERE ID NOT IN (SELECT ParentID FROM [SMD].[dbo].[ProposalFollowUp])

Popularity 3/10 Helpfulness 1/10 Language sql

Source: sqlerrors.com

Tags: find parent children sql

Link to this answer
Share Copy Link

Contributed on Sep 03 2022

thecodeteacher

0 Answers Avg Quality 2/10

sql - Find all children who are not parent

Contents

More Related Answers

sql - Find all children who are not parent

Closely Related Answers

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

sql - Find all children who are not parent

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.