>>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
To identify specific account(s) with a known sum :
select accountNo from myTable ;
having sum(amount)=lnKnownTotal ;
group by accounNo
Cetin