I am using Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production. Yes an ancient version but the license is embedded in an application that we use and this is the Oracle version that they use.
Here is an SQL query that I am using:
SELECT EntryDate, COUNT(OrderNo)
FROM Orders
GROUP BY EntryDate;
I get results like:
EntryDate COUNT(OrderNo)
--------- --------------
01-NOV-12 543
02-NOV-12 555
03-NOV-12 91
There are currently 472 rows with dates up to today, so the above is only a small snapshot of results.
Is it possible to group the results by month instead of the current date i.e. get results like:
EntryDate COUNT(OrderNo)
--------- --------------
Nov12 X
Dec12 X
Jan14 X