3 Replies Latest reply: Oct 10, 2013 4:13 AM by andrewmy RSS

    Sum per hour

    yxes2013

      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