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.
What Im currently doing:
SELECT TO_CHAR(dateTime, 'DD') DAY, TO_CHAR(dateTime, 'MM') MONTH, errormessage
FROM log
WHERE (...)
GROUP BY MONTH, DAY, errormessage
This results in ORA-00904: "DAY": invalid identifier (stops on the group by).
Any help? :D
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…