4 Replies Latest reply: Nov 14, 2016 12:07 PM by Phil White RSS

    Show Cust IDs having > 1 purchase in any 5 day period

    Phil White

      Can anyone tell me how to do the following...Show IDs of customers having > 1 purchase within any 5 day period


      I have a table that contains these fields: CUST_ID, UNIQUE_PURCHASE_ID, SALE_DATE