E-learn Weblog van Willem van Valkenburg
Blogging about OER, OCW, Blackboard, Mobile, Social Media and other interesting stuff
Blogging about OER, OCW, Blackboard, Mobile, Social Media and other interesting stuff
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);
| Print article | This entry was posted by Willem van Valkenburg on 27 March 2007 at 13:12:38 . Follow any responses to this post through RSS 2.0. |