E-learn Weblog of Willem van Valkenburg

je kan zelf de gewenste periode instellen door de data aan te passen:

/* You may need to use BB_BB60_STATS SCHEMA if searching for old dates */

SELECT COUNT(*)
  FROM (SELECT USER_PK1
          FROM BB_BB60.ACTIVITY_ACCUMULATOR a
         WHERE TIMESTAMP > TO_DATE('01/02/2007', 'DD/MM/YYYY')
            AND TIMESTAMP < TO_DATE('01/03/2007', 'DD/MM/YYYY')
           AND USER_PK1 IS NOT NULL
        GROUP BY a.session_id);