How to extract distinct group of associated records

View All Public Scripts Login to Run Script

Script Name How to extract distinct group of associated records
Visibility Unlisted - anyone with the share link can access
Description Sample dataset for extracting distinct set of related records. Extracted groups/arrays should look like below - Array 1: 100, 101, 102, 103, 104, 105 Array 2: 106, 107, 111 Array 3: 108, 110
Area SQL General / SQL Query
Contributor apurba.mailme@gmail.com
Created Wednesday December 12, 2018

Statement 1

CREATE TABLE TEST_DATA 
( 
SRC_REC NUMBER, 
TGT_REC NUMBER 
)

Table created.

Statement 2

INSERT INTO TEST_DATA (SRC_REC, TGT_REC) VALUES(100, 101)

1 row(s) inserted.

Statement 3

INSERT INTO TEST_DATA (SRC_REC, TGT_REC) VALUES(100, 102)

1 row(s) inserted.

Statement 4

INSERT INTO TEST_DATA (SRC_REC, TGT_REC) VALUES(103, 102)

1 row(s) inserted.

Statement 5

INSERT INTO TEST_DATA (SRC_REC, TGT_REC) VALUES(103, 104)

1 row(s) inserted.

Statement 6

INSERT INTO TEST_DATA (SRC_REC, TGT_REC) VALUES(102, 105)

1 row(s) inserted.

Statement 7

INSERT INTO TEST_DATA (SRC_REC, TGT_REC) VALUES(108, 110)

1 row(s) inserted.

Statement 8

INSERT INTO TEST_DATA (SRC_REC, TGT_REC) VALUES(107, 106)

1 row(s) inserted.

Statement 9

INSERT INTO TEST_DATA (SRC_REC, TGT_REC) VALUES(109, 111)

1 row(s) inserted.

Statement 10

INSERT INTO TEST_DATA (SRC_REC, TGT_REC) VALUES(111, 107)

1 row(s) inserted.

Additional Information