STRAGG with multiple partition
706654Dec 9 2009 — edited Dec 9 2009I want to use STRAGG LIKe this....
select col1,
col2, col3, stragg(distinct val) over (partition by col1, col2, col3 ORDER BY VAL
RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
from t
Instead of this ,we can use group by at the end. i want it in the above format to create object in BusinessObjects.
Please anyone help me.