Recursive sql

General

Recursive sql

I have this case in teradata, where in the certain set of child members (which are eventually parent members later) should be eliminated (along with their level 0 members ) and rest of the members alone should be fetched.

Ex:

100  101

101  102

102  103

105  106

500  100

450  500

500  600

and so on.

If i omit the member '100' all the members under that should also be eliminated.

is recursive function helpful to solve this ? Please help.

Tags (1)
1 REPLY
WAQ
Enthusiast

Re: Recursive sql

Please provide the DDL and DML

Also please help me understanding your issue. So if you omit 100 then your output would be:

105  106

500  100

450  500

500  600

It would be nice if you provide your input and the desired output.