Oracle日志分组查询（按天或者小时）

Oracle日志分组（按天）

按照日志生成日期进行分组统计Sql，如每日生成的访问日志有多少？

Oracle查询SQL语句

SELECT COUNT(*) AS GCOUNT,GDate FROM (SELECT to_char(createdate,‘yyyy-mm-dd’) as GDate FROM TABLE_LOG) GROUP BY GDATE ORDER BY GDATE ASC;

Oracle日志昨天分组（按小时）

按照某天的小时分组生成的记录数进行统计Sql

Oracle查询SQL语句

SELECT COUNT(*) AS GCOUNT,GDate FROM (SELECT to_char(createdate,‘yyyy-mm-dd-hh24’) as GDate FROM TABLE_LOG where createdte>to_date(‘2019-06-18 00:00:00’,‘yyyy-mm-dd hh24:mi:ss’) and createdate<to_date(‘2019-06-18 23:59:59’,‘yyyy-mm-dd hh24:mi:ss’) GROUP BY GDATE ORDER BY GDATE ASC;