此博客展示了如何使用Oracle SQL查询在特定日期范围内连接到环境的用户数量及总连接次数，提供了详细的SQL语句实现。
—Oracle Sql
—Number of users connected to the environment per day /’2009-08-16′
SELECT COUNT(Num) Users_Number FROM ( SELECT count(A.OPRID) AS Num
FROM PSACCESSLOG A
WHERE TO_CHAR(((A.LOGINDTTM ) + ( 0)),’YYYY-MM-DD’) >=’2009-08-16′
AND TO_CHAR(((A.LOGINDTTM ) + ( -1)),’YYYY-MM-DD’) <’2009-08-17′
GROUP BY OPRID)
—Number of connections to the environment per day / ‘2009-08-16′
SELECT COUNT(A.OPRID) AS Connections_Number
FROM PSACCESSLOG A
WHERE TO_CHAR(((A.LOGINDTTM ) + ( 0)),’YYYY-MM-DD’) >=’2009-08-16′
AND TO_CHAR(((A.LOGINDTTM ) + ( -1)),’YYYY-MM-DD’) <’2009-08-17′
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
