|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/18/2009 10:51:12 AM
Posts: 6,
Visits: 36
|
|
Can any body please help me convert the following oracle query to Teradata.
SELECT DISTINCT DECODE(product_id,'product1',0,'product2',0,'product3',0,LEVEL) Node_level,
USE,product_id,template ,header,tit1,num_chrts,product_order,producttext FROM productdata where use = 5
CONNECT BY product_id = PRIOR header AND LEVEL=2
START WITH product_id ='product1234' ORDER BY product_order
I tried with recursive, but how can I specify level = 2.
Regards.
Regards.
|
|
|
|