2007 Mar 07 5:06 AM
hi ,
if i have two or more numeric type fields in my table and i am using the
SUM to give me a grand total of only one field(column). Does the sum calculate
the sum of the field i wanted or all the fields with numeric datatypes present
in the table.
hi ,
if i have two or more numeric type fields in my table and i am using the
SUM to give me a grand total of only one field(column). Does the sum calculate
the sum of the field i wanted or all the fields with numeric datatypes present
in the table.
2007 Mar 07 5:08 AM
2007 Mar 07 5:11 AM
Hi vijay..
It will sum up all the numeric fields.........
u should be care full when you are using <b>sum</b> because the sum of the values in any field may cause an overflow and it may go for a dump.....
Suresh....
2007 Mar 07 5:18 AM
2007 Mar 07 12:34 PM
Hi
It will sum up values of fields with domain data type N, I, P.
Pulokesh
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |