This discussion is archived
3 Replies Latest reply: Oct 10, 2013 2:13 AM by andrewmy RSS

Sum per hour

yxes2013 Newbie
Currently Being Moderated

Hi all,

 

11.2.0.1

Aix 6.1

 

We have A BIG table (TAB1) where lots of transactions are inserted (12 rows every second). This table is reset to 0 every midnight. Starting at  1AM, at the end of every hour, on top of the hour, I have to sum all amounts in the table for the firsts hour and print a summary report for the hr. And do this for the next hours. How can I do this per hour?

 

Thanks,

 

Zxy

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points