hbutani/SQLWindowing — Issue #10: npath observations
Author: achaubal
Created: 2012-02-10 19:57:04+00:00
State: open

hey Harish,

thanks for the npath function,
a few observations,

i was running this:
from
npath(
partition by my_acct_no
order by my_dt,
'a.b.c',
<["a" : "my_score == 444","b" : "my_score == 555","c" : "my_score == 666"]>,
<[ "distinct my_acct_no" ]>)
select my_acct_no into path='npath_10_2011_09';

found that it doesn't like distinct in the final select. In this particular case, may be it doesn't matter since the partition is by the acct number. But how can I do Aster style distinct in the "outer" select?