Hey Guys,
I am attempting to target a particular day in order to update a table i have from another much larger table. I would like to only update the smaller table once a day with only the previous days stats.
The query i have below does not work, and i have been wrecking my head with it, so i thought i would see what the professionals thought.
Select
to_char(logtime,DD-MM-YYYY'),
COUNT(X),
COUNT(Y),
COUNT(Z)
from mytable
where logtime = sysdate-1
group by to_char(logtime,DD-MM-YYYY')
These are the results:
04-DEC-07 3 3 0
The actual results should be in the 100k's
Any help as always greatly appreciated.
Robert