>i have a HUGE table with account numbers. I am trying to find a certain sum, but I do not know which account no it is linked to. I need to sum totals in batches. Can anyone help? For example:
>
>Account No Total
>111222
>111222
>111222
>123668
>123668
>123668
>123668
>569999
>569999
>569999
>569999
>569999
>569999
>
>I need to get the total of 111222 then 123668, etc... I have over 100000 records to go through. Can anyone help me?? THanks!!
select accountNo, sum(Amount) as 'Total' ;
from mytable ;
group by accountNo ;
order by accountNo
Cetin