I am trying to decipher some code that loosely has this form
, max(<Date>) over (partition by ID, f2, f3 order by date rows between 1 following and 1 following)
qualify row_number() over (partition by ID, f3, f2, date order by f5, f6, f7) =1
my theory is that the where clause is resolved leaving me with 1 row per ID and the select to work with; is that correct?
Solved! Go to Solution.