Help with extract and count
I have a table with a list of transactions with a DATETIME field. Now I am trying to create a report listing the number of transactions each day, and am thinking or hoping I can do this with a single query, but so far have been unable to do so.
I have had some success using EXTRACT to get the DAY from the DATETIME field, but am having no luck in grouping or counting the number of transactions per day.
I've tried something like this along with a number of variants but have only been able to generate a count of all searches in the table.
SELECT count(searchtime) FROM searches GROUP BY EXTRACT(DAY FROM searchtime)
Any help would be appreciated.
Thanks
Subject
Written By
Posted
Help with extract and count
August 16, 2010 05:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.