Work Recipes et al

One can filter data from the partitioning clause of an analytic function using case ie: select  MIN(case when state <> 'CA' then createdate end) over (partition by id) MINACTIVEDATE from table;