JimBob

Hi all I'm trying to read a large amount of records, where I have to read the size of each record, sum them together for each day and present the result. Currently I'm using this sql (oracle): SELECT TO_DATE(REC.MODIFY_TS,'YYYY-MM-DD') Date, REC.DOC_SIZE "Amount bytes"FROM EKM.EKM_METADATA_RECORD_CHANNEL REC WHERE TRUNC(REC.MODIFY_TS) BETWEEN TO_DATE('01-01-2013','dd-mm-yyyy') AND TO_DATE('31-01-2013','dd-mm-yyyy') GROUP BY REC.MODIFY_TS, REC.DOC_SIZE ORDER BY Dato This SQL gives me around 1.2 mio records, which is some what of a pain to handle in Excel. The above is executed in TOAD against an Oracle DB. Result is shown like this:Date Amount Bytes01-01-2013 3904101-01-2013 39449etc. You help is needed to sum up the number of bytes per date, e.g. like this: Date Amount Bytes01-01-2013 12547885502-01-2013 235587496etc.