CODEWITHSUNDEEP
sql
Jane Liu
Jane Liu

Reputation: 61

What is this SQL code doing?

I have this table:

CREATE TABLE DAG(
  firstID NUMBER,
  secondID NUMBER,
);

What is this code doing?

Upvotes: 0

Views: 90

Answers (1)

Bob Jarvis - Слава Україні
Bob Jarvis - Слава Україні

Reputation: 50027

It's finding all the direct and indirect descendants of each ancestor.

SQLFiddle here.

Share and enjoy.

Upvotes: 1

Related Questions