>Hi all,
>I have a table with at least 200000 records in it.
>IdField and Payment are its fields.
>What is the fastest way to getting sum of payment for some records?
>Is SUM command suitable for this?
>SUM Payment ALL FOR IdField=2134 TO SumPayment

select sum(Payments) as TotalPayments from myTable where IDField = 2134 into cursor c_TotalPayments

?  nvl(c_TotalPayments.TotalPayments,0)