如何在PL/SQL中按天分组? [英] How to group by each day in PL/SQL?

问题描述

我正在尝试使用PL/SQL来获取每天的统计信息.

Im trying to get statistics for each day with PL/SQL.

每天都有几条记录，很多错误:-)我想按天对它们进行分组.

Each day have several entries, bukkets of errors :-) I want to group them by day.

我当前正在做什么:

SELECT TO_CHAR(dateTime, 'DD') DAY, TO_CHAR(dateTime, 'MM') MONTH, errormessage
FROM log
WHERE (...)
GROUP BY MONTH, DAY, errormessage

这将导致ORA-00904:"DAY":无效的标识符(在分组依据上停止).

This results in ORA-00904: "DAY": invalid identifier (stops on the group by).

有帮助吗? :D

推荐答案

SELECT TO_CHAR(dateTime, 'DD') DAY, TO_CHAR(dateTime, 'MM') MONTH, errormessage
FROM log
WHERE (...)
GROUP BY TO_CHAR(dateTime, 'DD'), TO_CHAR(dateTime, 'MM'), errormessage

列别名对GROUP BY不利，您需要完整的表达式.

Column aliases are no good for GROUP BY, you need the full expression.

这篇关于如何在PL/SQL中按天分组?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！