All Forums General
peterson 1 post Joined 11/12
01 Nov 2012
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.

WAQ 158 posts Joined 02/10
06 Nov 2012

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.

You must sign in to leave a comment.