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

    Sum per hour


      Hi all,


      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?